1
vote
1answer
48 views

Create a Google Sheets chart with multiple data ranges with separate key columns

I have this data: X1 Y1 X2 Y2 1 20 1 25 2 20 3 42 3 20 6 50 5 25 8 50 10 30 10 50 I want to create ...
2
votes
1answer
40 views

Creating a Chart with independently indexed series

I have a data series that looks like this: 0 317.59 1.4 317.59 1.5 408.77 2.15 408.77 2.25 440.46 2.98 440.46 3.08 471.37 3.12 471.37 3.17 ...
1
vote
1answer
212 views

2 axis line chart in Google Spreadsheets

I've set up a Google Spreadsheet to compare one set of stats against another. The stats are for traffic vs. an action the actions only happen once a day and not every day were as the traffic has more ...
1
vote
0answers
81 views

In a Google Sheets chart how do I prevent “Other” in the legend?

When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...
5
votes
2answers
3k views

Downloading charts from Google Spreadsheets in high resolution

I have a Google spreadsheet with data from which I've created a few charts using the built-in charting tool. Now, I'd like to download these charts in a format I can use in a PDF document I create ...
4
votes
1answer
3k views

How do I create a box plot chart in Google spreadsheet?

I want to create a simple boxplot from 1D data, which doesn't seem to be supported by the default Insert → Charts. There is a histogram gadget but I haven't seen any boxplot gadgets. Do I have ...
3
votes
2answers
1k views

Google spreadsheet charting count of items?

I have a spreadsheet that is filled by a form. It contains values like the following: Timestamp Person Category 2012-02-13 10.31.22 a x 2012-02-13 11.06.37 b y 2012-02-13 ...
4
votes
1answer
2k views

Chart of averages on Google Spreadsheets

I have day by day data. I would like to display a line chart with this daily data as well as weekly average bar chart. How can display daily as well as weekly trend chart by only having daily data ...
0
votes
2answers
631 views

not getting sub date granularity in google docs trend lines?

Anyone have an idea what I might have broken that prevents me from getting sub date granularity on google doc's spreadsheet's trend line graphs? My data is in variable increments, anywhere from 6 to ...
6
votes
1answer
1k views

How to label points in a scatter plot

I've tried using the built-in scatter plot chart and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data ...
1
vote
1answer
606 views

How can I charts based on day and month using dates in google spreadsheet?

I have a Google spreadsheet that has values like 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
0
votes
2answers
2k views

Laying out dates in Google Spreadsheet charts

I have a Google spreadsheet with measurements made at different dates. How can I make a chart with the dates spread along the x axis properly? The data looks like this 2010-09-01 80 2010-09-02 79 ...