Skip to main content

Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
41 votes
4 answers
167k 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 ...
Graviton's user avatar
  • 1,445
35 votes
3 answers
150k 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 ...
EboMike's user avatar
  • 743
22 votes
2 answers
100k 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 ...
orangenarwhals's user avatar
21 votes
2 answers
80k 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 ...
Shadow43375's user avatar
20 votes
3 answers
73k 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 ...
sam's user avatar
  • 6,979
19 votes
12 answers
43k 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 (...
Tomas Aschan's user avatar
19 votes
3 answers
20k 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 ...
THE JOATMON's user avatar
18 votes
3 answers
70k 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....
Carl R's user avatar
  • 335
14 votes
3 answers
23k 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 ...
digitaljoel's user avatar
12 votes
3 answers
40k 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 ...
wisbucky's user avatar
  • 1,267
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,...
bruno's user avatar
  • 789
11 votes
4 answers
58k 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, ...
Félix Paradis's user avatar
11 votes
4 answers
27k 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 ...
Dr-Bracket's user avatar
10 votes
3 answers
31k 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 ...
Elliott B's user avatar
  • 266
10 votes
3 answers
40k 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 ...
Scott M. Stolz's user avatar
9 votes
1 answer
23k 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: ...
Alistair's user avatar
9 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 ...
Robert Koritnik's user avatar
8 votes
2 answers
39k 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 ...
ooj's user avatar
  • 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 ...
Paul Weber's user avatar
7 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=...
Deanna's user avatar
  • 176
7 votes
3 answers
6k 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, ...
Cam Jackson's user avatar
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?
B Seven's user avatar
  • 517
6 votes
1 answer
15k 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?
nbarraille's user avatar
6 votes
3 answers
5k 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 ...
Kristina Kostina's user avatar
6 votes
2 answers
3k 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:
Franck Dernoncourt's user avatar
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 ...
Riccardo's user avatar
  • 589
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 ...
MZ_Guy's user avatar
  • 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 ...
Protector one's user avatar
5 votes
2 answers
7k 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....
Sun's user avatar
  • 880
5 votes
1 answer
14k 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 ...
CSS Apprentice's user avatar
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 ...
user avatar
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.
Asaf Nevo's user avatar
  • 171
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 ...
Mohamed Khamis's user avatar
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: ...
Leon Overweel's user avatar
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?
Graviton's user avatar
  • 1,445
4 votes
1 answer
12k 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?
awesame's user avatar
  • 43
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"); ...
ZygD's user avatar
  • 1,540
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 ...
Arlaharen's user avatar
  • 1,464
4 votes
1 answer
8k 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 ...
Charles's user avatar
  • 143
4 votes
1 answer
20k 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 ...
Riccardo's user avatar
  • 589
4 votes
2 answers
7k 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 ...
jsejcksn's user avatar
  • 397
4 votes
1 answer
551 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 ...
user9438400's user avatar
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 ...
Learner's user avatar
  • 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:...
linqu's user avatar
  • 143
4 votes
1 answer
564 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 ...
user66322's user avatar
4 votes
1 answer
298 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 ...
Tomáš Zato's user avatar
4 votes
0 answers
743 views

How do I specify a consistent interval for a date-range axis in a Google Sheet Chart

I have a Google Sheet with a set of deposits and withdrawls and the running balance. I have added a chart to the sheet, so I can visualize what the balance has been over time and when deposits or ...
Todd Powers's user avatar
3 votes
1 answer
19k 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 ...
Tomas's user avatar
  • 33
3 votes
2 answers
7k 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? ...
user3378649's user avatar
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 ...
WoJ's user avatar
  • 433

1
2 3 4 5