Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
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
34
votes
3
answers
148k
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 a ...
- 733
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
20
votes
3
answers
72k
views
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 ...
- 6,833
19
votes
2
answers
73k
views
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 ...
- 425
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
18
votes
12
answers
42k
views
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 (...
- 433
18
votes
3
answers
17k
views
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 ...
- 486
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
11
votes
2
answers
32k
views
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 ...
- 1,257
11
votes
1
answer
7k
views
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,...
- 769
10
votes
4
answers
51k
views
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, ...
- 200
9
votes
3
answers
26k
views
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 ...
- 246
9
votes
3
answers
38k
views
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 ...
- 213
9
votes
1
answer
22k
views
How do I modify the range of an existing Google Sheets chart?
I have inserted a chart into a Google sheet and need to modify the range of data it examines. I can manually define the range when I insert the chart using the chart editor as per the image below:
...
- 93
9
votes
3
answers
24k
views
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 ...
- 193
8
votes
2
answers
37k
views
How to reorder labels on Google sheets chart?
See the below chart that was created from Google Sheets:
I want to reorder the positioning of the bars in the x-axis - for example, move the "Over $121" bar to the far right and move the "Between $21 ...
- 181
7
votes
2
answers
19k
views
Variable Error Bars in Google Sheets Graphs
I have a data series that consists of multiple data series. I want to graph the average and the variance. I already calculated a single data series for the average and for the variance.
Now I want to ...
- 201
7
votes
3
answers
3k
views
How can I horizontally space data points on a chart when the dates are arbitrary?
Say I have events that occur on sporadic dates, like this:
Date
Qty
2022-01-01
100
2022-02-08
200
2022-06-17
150
2022-08-03
700
2023-01-27
300
I have rows for arbitrary days in Jan, Feb, June, ...
- 171
7
votes
1
answer
9k
views
How to choose custom colors for Google Spreadsheet charts?
When selecting the color for a line in a chart, I see 80 choices of colors. Is there a way to add new colors or set a color using RGB, HSV or HTML colors?
- 487
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
6
votes
1
answer
14k
views
Add average line to scatter graph
I have the following scatter plot in Google Sheets and I would like to add a line that averages all my points.
Can I do that and if yes, how?
- 255
6
votes
1
answer
3k
views
Stacked area graph of time/duration values
How can I create a stacked area graph of time/duration values?
I have a set of times for each date which correspond to each leg of a journey.
https://docs.google.com/spreadsheet/ccc?key=...
- 166
6
votes
2
answers
2k
views
Is there any way to enlarge the label area in Google Sheets?
I would like to increase the label area so that the label text doesn't get cropped. E.g. see red rectangle:
- 17.3k
6
votes
3
answers
13k
views
Set title of currently selected chart from named cell
There's a sample over here that will show how to set the first's chart title to the active cell:
function onOpen(){
SpreadsheetApp.getUi().createMenu('Charts').addItem('Update title of the first ...
- 579
5
votes
2
answers
8k
views
Does Google Sheets allow moving a chart to its own sheet?
I know that Google Sheets used to allow moving a chart to its own worksheet so that nothing else is in that sheet. All the instructions I've found for how to do so are no longer relevant to the most ...
- 163
5
votes
2
answers
3k
views
How can I embed a chart from a Google Spreadsheets in a Google Doc?
I would like to embed the chart from a Google Docs spreadsheet into a Google Docs Document, so changes to the original will be reflected in the embedded version. I found a way to embed a static image ...
- 227
5
votes
1
answer
12k
views
Snap chart to grid or place a chart in a cell?
Is there a way to snap charts to the grid?
In my spreadsheet, my chart hangs a little below my table, but I would like the chart to expand/contract with the cells on the left.
If this is an easy ...
- 193
5
votes
3
answers
4k
views
Chart labels disappear (stays outside the graph area) Google sheets
Really count on your help here, as it seems like I tried everything already.
Take a look at the graph: the last value label disappears (the location is right on the inner border of the graph, so the ...
5
votes
2
answers
11k
views
How to change the size of a published Google Spreadsheets chart that has its own sheet?
Google Spreadsheets offers the option to put a chart on its own sheet (instead of inserting it in the current sheet). This looks like a good idea for large charts.
However, I ran into an issue when ...
user79865
5
votes
1
answer
1k
views
Dynamic range in chart
I have a chart of my table, but I keep adding rows to it.
Is there a way to define the chart's Series/X-Axis/Range as part of a formula?
I want the graph to grow as my table grows - dynamically.
- 163
5
votes
1
answer
6k
views
Insert a datatable directly under my chart in Google Spreadsheets
How do I create a data table directly under my chart on Google spreadsheets? I want to achieve something similar to the figure below. In MS Excel it is called datatable and it is inserted by a click ...
- 335
5
votes
1
answer
3k
views
How can I stop Google Sheets charts from rounding down durations?
I've got a Google Sheets chart that displays the average pace of a day's rowing machine workouts (e.g. average the time to row 500m).
It looks like this:
The Query I'm using to get the data is this: ...
- 151
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
4
votes
1
answer
2k
views
How to access a gauge chart in Google Spreadsheets?
I have a gauge chart in my spreadsheet. I am looking for a line for accessing it.
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Gauge");
...
- 1,500
4
votes
1
answer
8k
views
How can I Set the Order on Items in a Chart Legend?
I have these two charts which pull the same data from the same table. The legend items appear in reverse order in the second chart. Anyone know how to make those match?
- 43
4
votes
2
answers
6k
views
Missing dates in time series are not showing blanks in x-axis
I made a combo chart where the x-axis is the date field. I have gaps in the date, but want my chart to reflect the gap. For example, I have big gaps in April, May, June, August, September, and October....
- 860
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
4
votes
1
answer
7k
views
Chart with points in Google Spreadsheets
I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need ...
- 143
4
votes
1
answer
15k
views
Showing percentages in google sheet bar chart
It looks like bar charts in Google Sheets won't support percentages.
Is this correct?
If so, how would a change the populating query that currently returns "count of"?
A single cell used as the ...
- 579
4
votes
2
answers
6k
views
Bar chart of time ranges in Google Sheets
Overview
I have a spreadsheet with 3 columns [Name, Start time, End time] which is for scheduling purposes. I want to create a bar chart showing all of the people's availability as a series of ranges ...
- 397
4
votes
1
answer
544
views
A chart with multiple series encoded by comma-separated names
I have the following table
I need a graph with dates on X axis (with the option to group by weeks/months/years), values on Y axis and lines for each name (A,B and C) representing the sum of values on ...
- 41
4
votes
1
answer
6k
views
How to increase precision of labels in Google Spreadsheets chart?
I created a chart in my Google Spreadsheets. For the sake of example let's say that horizontal labels are months of the year, for example 01.2016, 02.2016, 03.2016 etc. and vertical labels are amount ...
- 143
4
votes
1
answer
24k
views
Scatter chart with multiple data series
I want to create a scatter chart with Google Spreadsheets, which turns out to be very difficult. Based on a similar question here I came up with this approach:
What I want to achieve is sketched here:...
- 143
4
votes
1
answer
560
views
Can I use Google Chart Gallery in Google Spreadsheets?
Google Spreadsheets has column charts but I want to use "draw Annotations" like this (Annotations). Column chart doesn't show bar value as "draw Annotations" on top.
My chart included these:
First ...
- 81
4
votes
1
answer
297
views
Explaining proper meaning of columns to Google Sheets chart editor
I'm trying to make a simple chart displaying the number of events that occurred each month in X years. This means I want a chart that shows:
X colored lines, one for every year
Month names marked on ...
- 858
3
votes
1
answer
17k
views
Pie chart with sub-slices per category in Google Sheets?
I have a sheet that contains a list of books, with metadata about those books. Two columns that exist are the library within which the book is stored, and the condition of the book. I'd like to create ...
- 33
3
votes
2
answers
6k
views
Create chart from single column
I used a survey to collect data about people's opinion. The question is answered using a check-box (Yes/No). I would like to visualize the results using charts.
How can I do that using one column?
...
- 133
3
votes
1
answer
7k
views
How to merge x-axis data from two ranges?
Consider the data below:
1-Jan-2010 3 2-Feb-2009 9
5-Apr-2010 4 18-Apr-2010 5
10-Sep-2012 9 1-Oct-2011 8
The first two columns are for individual A, the last two for individual B.
Is it ...
- 423
3
votes
2
answers
9k
views
How to plot dates on a timeline in Google Sheets
I have a column of dates, eg.
2017-01-20
2017-01-25
2017-01-27
2017-01-30
2017-02-03
...
2018-12-20
I would like to create a plot where the x-axis is a contiguous range of dates from start to end (...
- 151