Tag Info

Hot answers tagged

8

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.


4

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 ...


3

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 ...


3

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 ...


2

It seems that this is possible to do in a Google spreadsheet now. If I enter the data from my question, highlight it and select insert chart from the menu, Google Spreadsheet will greate a trend graph with the points laid out correctly.


2

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 ...


2

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.


1

Please try with layout as shown. Select A1:C11 (or to suit), insert Line chart with Use row 1 as headers and Use column A as labels:


1

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.


1

I would put the count column in a new sheet that way if you start sorting the rows of data you won't mess up the columns with the data for the chart. I am assuming that you are using countif to make the data for the bar chart.


1

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


1

Looks like that's just a google doc - you can do that too, here are the instructions to embed it: http://docs.google.com/support/bin/answer.py?hl=en&answer=55244


1

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 ...


1

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.


1

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.



Only top voted, non community-wiki answers of a minimum length are eligible