Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
22
votes
2
answers
99k
views
How do I create a box plot chart in Google Spreadsheets?
I want to create a simple box plot 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 box plot gadgets.
Do I ...
- 323
18
votes
3
answers
64k
views
How to chart the 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 11.34....
- 335
3
votes
1
answer
5k
views
Can I precisely position charts in Google Sheets?
I am using Google Sheets to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report.
In this spreadsheet, I ...
- 69
7
votes
2
answers
16k
views
Chart of averages on Google Sheets
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 I display daily as well as weekly trend chart by only having daily data ...
- 2,205
2
votes
2
answers
2k
views
How to calculate and chart cumulative flex time?
Being a (productive) geek, I want to keep track of the trend of my flextime. I keep a personal document of my hours worked in Google Sheets, having one column for hours worked every day. By ...
- 121
-2
votes
2
answers
1k
views
Not getting sub date granularity in Google Sheets trend lines
My data is in variable increments, anywhere from six to eight hours apart like so:
1-1-2011 00:00:00 100
1-2-2011 00:00:00 103
1-3-2011 00:00:00 107
1-4-2011 00:00:00 109
1-4-...
- 155
2
votes
1
answer
1k
views
How to plot time series graph with categories?
I've data in Google Spreadsheets, with columns as follows:
DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2
For example:
22.12.2010 APPLES 1 20
23.12.2010 APPLES 100 20
23.12.2010 ORANGES 32 12
I need ...
13
votes
3
answers
22k
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 ...
- 233
2
votes
3
answers
6k
views
How can I chart based on day and month using dates in Google Sheets?
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 ...
- 175
4
votes
2
answers
8k
views
Laying out dates in Google Sheets charts
I have a Google Sheets with measurements made at different dates. The data looks like this:
2010-09-01 80
2010-09-02 79
2010-09-10 81
I want the points that make up the data to be laid out so that ...
- 1,424
3
votes
3
answers
23k
views
Why don't Google Sheets graphs lay out my points correcty?
When I try to make a simple graph of some points in a Google Sheets said points do not end up where I want them to in the graph. Using data like this I expect a straight line in my graph:
col A col ...
- 1,424
2
votes
2
answers
2k
views
Graphs with Google Spreadsheets - collapse data into one 'category'
I have a set of data which is similar to the following:
Groceries 5.00
Groceries 14.75
Groceries 6.37
Dinner Out 43.50
Dinner Out 15.00
I'd like to be able to use this data to create ...
- 297
5
votes
2
answers
13k
views
Plot Multiple Graph in Google Spreadsheet
I know how to plot a graph in google spreadsheet. But how to plot multiple graphs, with different X and Y values in Google Spreadsheet?
- 1,415
39
votes
4
answers
161k
views
How to plot time series graph in Google Sheets?
I know it is possible to plot graph or chart in Google Sheets but the problem with current plotting way is that you can only specify the Y, but not the X, and as such there is no way to plot a time ...
- 1,415