Hot answers tagged charts
My 50 cents: Google Visualization\Charts. Pros: Free Quite easy to use Charts look great Cons: Image size is limited. Some tools (like Drastic Treemap) are buggy.
From your spreadsheet, select the cells with data you'd like to include in the chart. Alternatively, you can select a range or multiple ranges of data from within the charts dialog. You can do so by clicking Select range... and entering one or more ranges by clicking Add another range. Note: It helps to label the data in your spreadsheet before creating a ...
It looks like there is nothing you can do from the options that they give you, since the build in functionality to Save Image or Copy Chart, results to a low-resolution images. A wild idea would be to do the following (if you really want to have a high-res result, but this is not something that you could do for many charts): Click on Publish Chart Choose ...
GitHub now offers such graphs using the Pulse feature. By clicking on the left-most heartbeat icon of the repository you desire and setting the desired timeframe, you can see the number of issues created and resolved, though not in a graph manner, but in the form of a bar.
I don't see how your example image relates to your example data because with your data I get: but at least the above shows a secondary vertical axis is possible (though only for certain chart types) and it did seem necessary to replace the blanks in your ColumnC with 0.
The closest thing to a Boxplot Chart is a Candlestick Chart. You could calculate all the data needed to plot a box chart: The Five Number Summary and plot each serie individually. Apparently, the width of the box isn't important. I've prepared an example file: Box Plot example (sample data). Screenshots In Google Apps Script, the box charts are ...
This is an excellent time to use a pivot table. Select columns B and C, then click on Data → Pivot table report... In the Report Editor column on the right side: In the Columns section, add the Category field. Uncheck Show totals if you do not want the Grand Total column. In the Values section, add the Category field and summarize by COUNTA. Now ...
Ok, it appears to be caused by entering just enough data to tip the balance somehow. Throw this data into a sheet and apply a timeline chart. You'll get a nice curved line. 1/11/2011 00:00:00 1173 1/12/2011 00:00:00 1270 1/13/2011 00:00:00 1387 1/14/2011 00:00:00 1434 1/15/2011 00:00:00 1458 1/17/2011 00:00:00 1531 1/18/2011 00:00:00 ...
Maybe you're using the wrong chart type for display this kind of information. When I selected time line from the Charts for the above data, I'm getting an interactive chart, exactly like the one they are using in Google Finance.
Basically what you're looking for is something like Pivot Tables of Excel, where you can group by anything you want. Unfortunately there is no such support in Google Spreadsheet. What you (or someone) could do though is to write a simple script to group them for you. If you're interested you can start with some tutorials.
It looks like it's still not yet possible with Google spreadsheets. Look at the thread on google's support forum for tips and updates Google Forums - date in a chart
Only top voted, non community-wiki answers of a minimum length are eligible