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
35 votes
3 answers
149k 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
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
21 votes
2 answers
79k 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
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
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
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
0 votes
1 answer
1k views

Multiple Groups Graph on Google Sheets. Please Help

I got the following table on google sheets. Text version +----+---+---+----+ | | A | B | C | +----+---+---+----+ | 1 | 1 | 2 | 1 | +----+---+---+----+ | 2 | 2 | 1 | 1 | +----+---+---+----+ | ...
Or24's user avatar
  • 13
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
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
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
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
2 votes
1 answer
1k views

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

I'm trying to create two lines on the same graph, with one being 'Line A' based on Data labeled 'A' and 'Line B' based on B. The X-axis would be the date and would expand over time as more entries ...
zzzjoshzzz's user avatar
2 votes
1 answer
433 views

How to make a bold sparkline in Google Sheets?

Is it possible to thicken the line graph shown when using the formula =SPARKLINE(L4:L)?
orschiro's user avatar
  • 5,518
2 votes
3 answers
7k views

How can I chart based on day and month using dates in Google Sheets?

I have a Google spreadsheet that has values like: 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
Good Person's user avatar
2 votes
1 answer
2k views

Same x-axis for multiple graphs in same plot window

I am trying to do exactly what the answer to this other question explains (I have several sets of data to be plotted in one graph with the same x-and y-axis); but with one difference: I don't have ...
Steeven's user avatar
  • 610
1 vote
2 answers
8k views

In Google sheets is it possible to have a combined chart with stacked columns?

I currently have a simple combined chart with a revenue line and columns. For what I am trying to communicate with this graph, I would really like to have stacked columns in addition to my revenue ...
Blake's user avatar
  • 11
1 vote
1 answer
824 views

How to get most frequent terms from a set of lists?

I have a list on Google Spreadsheets. Each line is a mission, and one of the columns indicates who I've worked together on the mission (which is between 1 and 3 people). The format is "Aquaman, Batman,...
Technically Not a Human's user avatar
1 vote
1 answer
444 views

Timestamps in scatterplot

I have a Google spreadsheet with two sheets. The first one is for data input from my Android phone using Tasker. Input sheet looks like this: clock duration 16,25 29 6,45 23 16,3 35 where "...
Ou Tsei's user avatar
  • 111
1 vote
1 answer
2k views

Change colors on graph

I have a graph on google sheets, and want to change the background color for certain values on x axis. For example, from a value A to a value B (on x axis) I want a background color 1, then from ...
Ashenden's user avatar
1 vote
1 answer
232 views

Stop Google Sheets from removing trailing zeros

Can anyone suggest a Google Sheets formula to stop removing trailing zeros? (but allow truncating to 6 digits after decimal? 00.000000 29.9918650 -93.958005 29.991865 -93.958005 (1mi:29.991865:-...
Most Interesting Man In World's user avatar
1 vote
1 answer
160 views

How to add a date to a cell next to an cell with an imported value

In column A I have a value added each day from the tab/cell TOTAL/A1 by this script: function dailyLog() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sourceSheet = ss.getSheetByName('...
Fredrik's user avatar
  • 11
1 vote
1 answer
526 views

Display month and year on chart

I have a line chart created after data that's stored like this: A B C D 1 | 2017 | | 2018 | | 2 | NOV | | FEB | | 3 | 0 | 0 | ...
w00t's user avatar
  • 111
0 votes
1 answer
590 views

Google Sheets, coloring a line depending on another column (conditional formatting for lines)

Imagine I have a table like the following. Column A is the x-axis, e.g. time. Column B is some condition, e.g. 1 and 0 for yes and no or true and false. Column C has the y-values. I'd like to create ...
Michael Fischer's user avatar
0 votes
1 answer
1k views

Cumulative Timeline Plot Google Sheets

To make the job application process a bit more fun on the side, I am gathering some statistics on it. I would love to plot "number of applications submitted over time". I am limited to ...
Philipp Stephan's user avatar
0 votes
1 answer
343 views

Google Spreadsheets Charts: Drawing continuous chart based on multiple data ranges

I have a big set of data that I split it into 2 ranges (here I am just showing small data for clarification). I want to draw one chart based on those 2 ranges, to get a result as the "Desired ...
philippos's user avatar
  • 101
0 votes
2 answers
2k views

Create chart with total for each score

I have a column within a Google Spreadsheet with values like this: 96 97 96 100 97 97 100 97 95 95 96 I'd like to add a bar chart where each bar represents one of the values and the height of the ...
user avatar
0 votes
1 answer
282 views

1 plot with several lines with a common X axis but unique X and Y values... is this possible?

I am trying to create a graph which shows several smooth lines that are defined by an X and Y value. the problem is that they have to share the X-axis. Is there a way to efficiently add the other ...
Peter Pan's user avatar