Tag Info

Hot answers tagged

7

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.


5

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


5

You can copy the chart and paste it into the sheet you want; then delete the chart sheet. The copy button is in the toolbar: Copying preserves the changes made to the chart.


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


3

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

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

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.


2

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

To find the approximate usage, say, in June 2015, I would look at the last reading before this month began and at the first reading after it ended; then pro-rate the use accordingly. This guarantees the usage estimate will be based on an interval that's at least a month long. I used the Match command to determine the relevant rows for each month, then ...


1

My understanding of your requirement is as below, though this does not apply your sample data: The layout of the left four columns is required - in effect I have substituted: 10 100 30 110 60 150 80 180 for your sample data in the OP. I selected the data area, Charts, Charts, Line and checked both Use row 1 as headers and Use ...


1

As far as I know, there isn't a way to do that. Instead, create a Web App so will have access to more options for your charts. One alternative is to use Google Apps Script HtmlService. Example Code.gs function doGet() { return HtmlService.createHtmlOutputFromFile('index') .setSandboxMode(HtmlService.SandboxMode.IFRAME); } index.html ...


1

The Chart Gallery in Google Developers - Google Charts is a collection of demos about using code to create charts. This charts can't be inserted in a Google Sheets but they could a Google spreadsheet as data source. It's worth to say that the Column Chart that can be inserted in a Google spreadsheet, but could be a bit tricky to add the annotations. For ...


1

As far as I know, at this time charts in Google Sheets don't include a datatable option. References Create a chart or graph - Docs Editors Help Editing and formatting your chart - Docs Editors Help


1

Try exporting the chart as a PNG file, then inserting that into a Google Doc.


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

You can use the addon g(Math) it is under statistical display and will create a box and whisker chart as below.


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