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 ...
- 361
23
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 | ...
- 897
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. ...
- 263
12
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.
- 121
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
- 26k
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 ...
- 951
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 ...
- 17.3k
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 ...
- 1,619
6
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 ...
- 61
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 ...
- 51
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 ...
- 26k
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 ...
- 227
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
...
- 26k
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
...
4
votes
Accepted
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 ...
- 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","...
- 1,958
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 ...
- 302
3
votes
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 ...
- 31
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 ...
- 31
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 - ...
- 850
3
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 ...
- 246
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
- 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 ...
- 46
3
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 ...
- 817
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 ...
- 43.9k
Only top scored, non community-wiki answers of a minimum length are eligible