Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
23
questions
34
votes
3
answers
148k
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 ...
- 733
39
votes
4
answers
161k
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 ...
- 1,415
19
votes
2
answers
73k
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 ...
- 425
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?
- 1,415
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 ...
- 227
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 ...
- 143
1
vote
1
answer
577
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 ...
- 11
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 |
+----+---+---+----+
| ...
- 13
7
votes
3
answers
3k
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, ...
- 171
6
votes
1
answer
14k
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?
- 255
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 ...
- 579
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 ...
user79865
2
votes
1
answer
836
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 ...
- 31
2
votes
1
answer
357
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)?
- 5,468
2
votes
3
answers
6k
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 ...
- 175
1
vote
2
answers
7k
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 ...
- 11
1
vote
1
answer
409
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 "...
- 111
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('...
- 11
1
vote
1
answer
734
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,...
0
votes
1
answer
241
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 ...
0
votes
1
answer
264
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 ...
- 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 ...
spiffy
0
votes
1
answer
194
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 ...
