Skip to main content
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 ...
megamillions's user avatar
25 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 | ...
KyleMit's user avatar
  • 927
15 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. ...
Classified's user avatar
15 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.
Martin Rausch's user avatar
7 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 ...
ttarchala's user avatar
  • 1,679
7 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 ...
loqk's user avatar
  • 71
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
user0's user avatar
  • 26.7k
7 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 ...
Nathan Arthur's user avatar
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 ...
pnuts's user avatar
  • 17.7k
5 votes
Accepted

Pie chart with sub-slices per category in Google Sheets?

your dataset of A1:C is not in "good" shape for creating a chart, so first, you will need to re-shape it by adding few formulas in auxiliary columns which you can hide when done in cell E1 paste this ...
user0's user avatar
  • 26.7k
5 votes
Accepted

How can I Set the Order on Items in a Chart Legend?

In Google Sheets, the order of the chart legend is based on the order of Series added to the chart. To reorder the legend, edit the chart and remove all series. Add the series back in the order that ...
varogen's user avatar
  • 166
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 ...
Harun Alikadić's user avatar
4 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 ...
user0's user avatar
  • 26.7k
4 votes
Accepted

How to merge x-axis data from two ranges?

Is this roughly what you want?:
pnuts's user avatar
  • 17.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 ...
Theo's user avatar
  • 41
4 votes

Chart labels disappear (stays outside the graph area) Google sheets

This is a known (and so far unsolved) Google Sheets bug. A workaround consists on adding an additional series with a single line and then making it invisible. The number associated with such line must ...
Yuri Sucupira's user avatar
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","...
pjmg's user avatar
  • 2,010
4 votes
Accepted

How to reduce number of X axis labels?

Answer: ... -> Edit chart -> Customize -> Gridlines -> Horizontal Axis (in drop down) -> Major gridline count Under the Major gridline count you can select or type however many dates you want to ...
CodeCamper's user avatar
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 - ...
Sun's user avatar
  • 880
3 votes

Create chart from single column

Just select A1:A4, Insert > Chart...:
pnuts's user avatar
  • 17.7k
3 votes

Downloading charts from Google Sheets in high resolution

Update from 2017, now Google Sheets provides a way for to download the charts by clicking on the three vertical dots at the top rightmost corner of the chart and clicking on save image. Even though ...
Jorge Heleno's user avatar
3 votes

How to chart the count of items?

This is possible using the following steps: Select column C Open the Chart Editor from the menu Insert > Chart The chart should be correctly setup, if not, the settings are: Stacking: None Data ...
pnuts's user avatar
  • 17.7k
3 votes
Accepted

How to create an histogram with inner divisions in Google Sheets?

If you have a list of grades in the form of raw data, to use a stacked bar chart to make an histogram first you should create a table of frequency distributions. Since you want to show "inner ...
Rubén - Volunteer Moderator -'s user avatar
3 votes

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

I think I found the answer to this. 1. Select Chart Editor 2. Select Vertical axis Should be an option there for Reverse axis order
Marc's user avatar
  • 31
3 votes
Accepted

How to make Google Sheets draw trends in a spreadsheet

Use the SMA (Simple moving average). It works as follow Take W points back (e.g. 3, 5 or 10, that's your window size) and do an average for them. This will create a new point Use those newly created ...
Shadi Moadad's user avatar
3 votes

Graphing two lines in Google Sheets based on values in first column

your data should be in this format: if this is not the option you can transform it with this formula: =QUERY(A1:C, "select B,sum(C) where A is not null group by B,C pivot A", 1)
user0's user avatar
  • 26.7k
3 votes

Missing dates in time series are not showing blanks in x-axis

Unfortunately the Combo Chart doesn't support the Treat labels as text for the horizontal axis. The alternative is to use a different chart type like: Area chart Column chart Line chart and maybe ...
Rubén - Volunteer Moderator -'s user avatar
3 votes
Accepted

How to overlay two charts?

Google does not have a feature to do what you want. However, a work-around may be possible by making the line transparent. This is untested. Create two graphs Edit the Line graph to remove the ...
Tedinoz's user avatar
  • 5,741

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