Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.
32 votes
Accepted

Create a Google Sheets chart with multiple data ranges with separate key columns

Please try with layout as shown. Select A1:C11 (or to suit), insert Line chart with Use row 1 as headers and Use column A as labels:
user avatar
  • 16.7k
26 votes

2-axis line chart in Google Sheets

What you need to do is a few steps: Insert to Chart then add your Data Series, as you normally would with a Single Axis chart. (Optional) Change chart type to Line. You can change it to anything else ...
user avatar
20 votes
Accepted

How to plot time series graph in Google Sheets?

Google should now respect X-axis date values for Line, Area, Scatter, and Time Line charts. For example, if you have the following data*: | Date | Value | |------------|-------| | 01/01/2016 | ...
user avatar
  • 847
15 votes

How to label points in a scatter plot?

Today's Google announced that now it's possible to add data labels. For the data included in the question, Move the first column to the rightmost position. | A | B | C | -+---+---+------+ 1| ...
user avatar
  • 41.7k
11 votes

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

As of today's version of Google Sheets (on Dec 6, 2019), we can do this to make the values appear: Create your pie chart (assuming you know how) Click in the upper right of the chart, on the 3 dots. ...
user avatar
7 votes

How do I create a box plot chart in Google Spreadsheets?

You can use the addon g(Math) it is under statistical display and will create a box and whisker chart as below.
user avatar
7 votes
Accepted

Does Google Sheets allow moving a chart to its own sheet?

select the chart click on three dots select either Copy chart or Move to own sheet
user avatar
  • 24.5k
6 votes
Accepted

Variable Error Bars in Google Sheets Graphs

Not really a better answer but more expressing your idea in a different way. Plot Average-variance under, variance under, variance over: The above is a stacked area chart with the first series ...
user avatar
  • 16.7k
6 votes
Accepted

How can I skip columns in a Google Spreadsheets Chart?

In the chart's menu, go to Advanced Edit..., then in the Chart types tab you can enter the range. If you need to skip some columns, enter 2 ranges separated by a comma, one to left of the column you ...
user avatar
  • 1,519
5 votes

Downloading charts from Google Sheets in high resolution

Just use the standard print dialog in Chrome (File -> Print / do not use the shortcut cmd+p, as this opens up a Google sheet specific print pop-up) and chose "save as PDF" (tried on a Mac/OSX). This ...
user avatar
  • 51
5 votes

How to rename a series in Google Sheets chart?

Make sure your graph shows the legend. Then, double click on the legend symbol you want to add a name to and type your name in the "Text Label" box in the menu that appears.
user avatar
4 votes

Downloading charts from Google Sheets in high resolution

Google Charts are HTML5 SVG objects. Means vectors. Means highest possible quality. I still do not get it why Google doesn't provide native solution to export in SVG. Google Chart to SVG vector file ...
user avatar
4 votes

How can I embed a chart from a Google Spreadsheets in a Google Doc?

In lieu of a standard solution, I created a crude Google Apps Script to reload my embedded image upon opening the document. Open the Script Editor, and enter the following code, substituting the URL ...
user avatar
4 votes
Accepted

How to merge x-axis data from two ranges?

Is this roughly what you want?:
user avatar
  • 16.7k
4 votes

How do I combine two different types of charts to compare two types of data?

Maybe this is what you wanted (the chart is in the example you linked): I used a combo chart, applies column style for all series, but asked only for the "Total" series to be displayed in the right ...
user avatar
  • 41
4 votes

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

This may not be a direct help since i think you also need an offset, not just a reversal, but for people who just need to reverse the whole axis, this may work It's a ridiculous workaround. Make a ...
user avatar
  • 41
4 votes
Accepted

How to make a bold sparkline in Google Sheets?

Yes, it is parameter linewidth. Example : =SPARKLINE(L4:L;{"linewidth"\3}) Reminder on how to construct a =sparkline : =SPARKLINE("range",{"charttype"\"line","xmin"\0,"ymin"\0,"color"\"orange","...
user avatar
  • 1,897
4 votes

How to use "aggregate" chart feature on Google Sheets

The aggregate feature allows you to aggregate all values that share an identical x-axis key. Normally, if you have duplicate x-axis keys, your chart will look something like this, with values having ...
user avatar
3 votes

How can I make Google Sheets tell me how many of each date are in a column?

You can reproduce the required table using a formula (this will only work on the newest version of Sheets): =QUERY({A:A,A:A},"select Col1, count(Col2) where Col1 is not null group by Col1 label Col1 '...
user avatar
  • 2,249
3 votes
Accepted

Chart with points in Google Spreadsheets

Copy of a more extreme example of 'co-linearity`: seems to have pointed to an acceptable solution/workaround. That is, add data point markers (Point size, in Customise in Chart Editor) - in the ...
user avatar
  • 16.7k
3 votes

How to choose custom colors for Google Spreadsheet charts?

[Edited 2022] This is now possible natively. Edit the chart > Series > Line Color > Custom The custom color picker supports hex color code input. Importing more complex charts via an xlsx ...
user avatar
  • 31
3 votes

Is there any way to enlarge the label area in Google Sheets?

If you right-click on the chart itself (i.e. the central area) and select the 'Edit: > Axis > Axis area' menu item, it allows you to edit the area the chart occupies. You can drag it up from the ...
user avatar
  • 302
3 votes
Accepted

Snap chart to grid or place a chart in a cell?

as already anticipated, snapping chart to the grid is not possible charts can be resized and moved around across the whole sheet to millimetre scope position and/or size of charts can't be dynamic ...
user avatar
  • 24.5k
3 votes
Accepted

How to use Google Spreadsheets to chart completed tasks using time series graph?

I assume you know how to make a chart where the X is date, Y is your moving average (if you have the value). Moving Average Google Sheets Used Google searches to find: How to sum up rows above - ...
user avatar
  • 800

Only top scored, non community-wiki answers of a minimum length are eligible