Web Applications Stack Exchange
Web Applications Stack Exchange

Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

215 questions
41
votes
4 answers

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 series graph (time vs displacement for…
Graviton
  • 1,445
  • 7
  • 24
  • 34
35
votes
3 answers

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 a graph that overlays two lines, one with X1 as X…
EboMike
  • 753
  • 2
  • 6
  • 12
22
votes
2 answers

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 have to make my own gadget using Google Charts API?
orangenarwhals
  • 323
  • 1
  • 2
  • 8
21
votes
3 answers

Statically positioned chart (ignore scroll)

I have a Google Sheets document with four columns of data. I have a chart on the right side. When you scroll down to see all the data, the chart scrolls up off the screen. Is there a way to make it static or float?
THE JOATMON
  • 516
  • 2
  • 4
  • 14
21
votes
2 answers

How to change the values of a pie chart to absolute values instead of percentages in Google Sheets

I want to be able to change the percentages under each of the fruit names to absolute numbers (the respective quantities). I tried changing the 'slice label' but that only added the numbers over the slices which is not the desired result for this…
Shadow43375
  • 465
  • 1
  • 5
  • 11
20
votes
3 answers

2-axis line chart in Google Sheets

I've set up a Google Sheets to compare one set of statistics against another. The statistics are for traffic vs. an action. The actions only happen once a day and not every day whereas the traffic has more volume and happens every day. What I want…
sam
  • 7,107
  • 42
  • 100
  • 140
19
votes
13 answers

Downloading charts from Google Sheets in high resolution

I have a Google Sheets 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 locally (I would prefer .pdf, but .png is OK…
Tomas Aschan
  • 453
  • 1
  • 5
  • 12
18
votes
3 answers

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.32 c x 2012-02-14 09.22.35 d …
Carl R
  • 335
  • 1
  • 2
  • 8
14
votes
3 answers

How to rename a series in Google Sheets chart?

By default, a Google Sheets chart will use the first row as the the name of the Series. But if you are selecting a range in the middle of the table (for example, rows 38-100), then you can't use the first row as the name. You have to uncheck Use row…
wisbucky
  • 1,287
  • 2
  • 14
  • 14
14
votes
3 answers

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 like the following: | Name1 | 36 | 1 | | Name2 |…
digitaljoel
  • 243
  • 1
  • 2
  • 6
12
votes
4 answers

How to reverse the y-axis in a Google Sheets graph?

I have data that represents the depth of an open mine in a transversal view. Currently, it looks like this: But since it represents the depth of a mine, I'd rather have it "flipped". So the y-axis, instead of going from 0 to 400, would need to go…
Félix Paradis
  • 220
  • 1
  • 2
  • 8
11
votes
1 answer

How to move a standalone chart back to an existing sheet?

I regret moving my chart to a new spreadsheet in Google Sheets. How do I move it back? Using the revision history to undo the edit is not an option, since it has been a while since the original move, and I would have to undo all the changes since…
bruno
  • 839
  • 3
  • 10
  • 21
11
votes
4 answers

How to reduce number of X axis labels?

I have a chart with dates along the X axis, but the chart displays them quite close together, producing a rather ugly graph. How might I reduce the number of visible labels to increase the readability a little? Edit: Sheet in question…
Dr-Bracket
  • 213
  • 1
  • 2
  • 7
10
votes
3 answers

How to use "aggregate" chart feature on Google Sheets

Line graphs and most other types in Google Sheets have a checkbox for "aggregate" in the setup tab. I've tried looking through the instructions but I can't find any documentation on how to use this feature. Can anyone point me in the right…
Elliott B
  • 266
  • 1
  • 2
  • 9
10
votes
3 answers

How can I skip columns in a Google Spreadsheets Chart?

I have a table of data in a Google spreadsheet that we want to use to create multiple charts. The issue we are facing is that some of these charts omit certain columns. We don't want to remake the table multiple times. Example: Row 1 = Labels for…
Scott M. Stolz
  • 223
  • 1
  • 2
  • 7
1
2 3
…
14 15