Tagged Questions

0
votes
0answers
108 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 ...
2
votes
0answers
32 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 ...
4
votes
1answer
1k 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 ...
2
votes
1answer
585 views

Google spreadsheet: box plots?

I want to create a simple boxplot from 1D data, which doesn't seem to be supported by the default Inesrt>Charts. There is a histogram gadget but I haven't seen any boxplot gadgets. Do I have to make ...
2
votes
2answers
346 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
1k 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
496 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 ...
5
votes
1answer
670 views

How to label points in a scatter plot in Google Docs

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
364 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
1k 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 ...