Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
1
vote
0
answers
746
views
How to make median appear in a box plot chart in Google Sheet?
I want to know how can I make the median line appear in the box plot chart?
- 111
0
votes
1
answer
273
views
Histogram for scattered dates (some days have no row, they should still show up, with height zero)
I have this data (as you can see I did zero pushups on the 21st/23rd/24th):
Date Pushups
9/20/2020 150
9/22/2020 100
9/25/2020 200
What is the easiest way to make a histogram with this data?
...
- 8,714
0
votes
2
answers
84
views
Add % sign in Data Labels Google Sheets [closed]
I have a simple chart in Google Sheets. Currently, the data labels are just numbers. I want to append a % sign infront of each value. How can I do so?
https://docs.google.com/spreadsheets/d/1wyubPje-e-...
- 109
0
votes
1
answer
96
views
Copy from individual cell in Google Sheets Table Chart
I'm using appscript to build and insert a table chart into a sheet when a button has been pushed.
var chart = sheet.newChart()
.setChartType(Charts.ChartType.TABLE)
.addRange(outrange2)
.setPosition(2,...
0
votes
1
answer
90
views
How to make time series chart, where all rows are labelled and dates are not unique?
Say I have some data like so
| Month | Count | Type | | |
|-------|-------|------|--- |--- |
| 1 | 2 | A | | |
| 1 | 3 | B | | |
| 2 | 1 | A | | ...
2
votes
1
answer
858
views
Google Sheets: aggregate and extrapolate irregular data over time
I have a list in which I now-and-then (no fixed interval) enter the available budget.
Most of all I want to extrapolate this to a future trend of the coming 10 years. (no rocket science, more of an ...
- 125
2
votes
0
answers
22
views
Customize point style in scatter chart [Google Sheets]
Is there a way to add new point shapes (import new symbols) in Google Sheets charts? Also, can I customize there color fills, or remove the infill color?
- 121
1
vote
0
answers
784
views
Progress bar with Bar Chart in Google Sheets
I have a 2 tasks that I would like to keep track of my progress in Google Sheets with a percentage bar chart.
Google Charts is not allowing me to separate the data into two series. They have the same ...
- 111
3
votes
1
answer
8k
views
How can I Set the Order on Items in a Chart Legend?
I have these two charts which pull the same data from the same table. The legend items appear in reverse order in the second chart. Anyone know how to make those match?
- 33
1
vote
0
answers
75
views
Link chart heading to cell
I would like the main heading of a Google Sheets chart to change dynamically by linking it to the value of a cell. The header input field does however not seem to handle formulas like =I4, it just ...
- 111
1
vote
0
answers
16
views
How to automatically add data series to line chart when new row of data added to underlying sheet?
I have a line chart where the X-axis is Day of Week and Y-axis is a count. The underlying sheet has Sunday dates in column A, where each row is one week apart, and columns B-H have count values for ...
- 11
1
vote
1
answer
266
views
Google Sheets graph jump by 1 on the horizontal axis
How can I change the graph’s horizontal axis to show a jump by 1 instead of 2?
- 11
2
votes
1
answer
6k
views
How do I format the horizontal axis labels on a Google Sheets scatter plot?
The settings for the vertical axis on a Google Sheets scatter plot provide an option for selecting or customizing a format for the labels, but no corresponding option is provided for the horizontal ...
- 660
2
votes
1
answer
930
views
Bar chart that counts rows google sheets / Pandemic-like chart
I have a google form linked to a google sheet (so every time somenone fills the form, a new row is created). I would like to make a chart that count the number of rows each day. In the example shown ...
- 23
0
votes
1
answer
105
views
How to create a chart in Google Sheets for yearly value growth when the data is separated by quarters?
How to create a chart in Google Sheets for yearly value growth when the data is separated by quarters?
For
- 103
2
votes
1
answer
607
views
Getting a line graph to begin at the Y-axis?
Really simple question that's driving me nuts for a while. How do I get my line graph in Google Sheets to begin at the Y axis - i.e. so there isn't a gap before the January 2020 date?
I've been ...
1
vote
1
answer
149
views
Cannot create pie chart in which all values are identical
I am unable to create a pie chart in which all responses are identical, or, in other words, in which 100% of the responses are represented by a single value. When I try to create such a chart, for ...
- 161
11
votes
2
answers
31k
views
How to rename a series in Google Sheets chart?
By default, a Google Sheets chart will use the first row as the the name of the Series. But if you are selecting a range in the middle of the table (for example, rows 38-100), then you can't use the ...
- 1,257
1
vote
0
answers
64
views
Multiple y-values for one x value
I'm trying to graph the following values:
0degr 0.24-0.27
20degr 0.22-0.28
40degr 0.22
60degr 0.2
How do I graph a range such as "0.24-0.27" in google sheets?
Thank you!
- 11
4
votes
2
answers
6k
views
Missing dates in time series are not showing blanks in x-axis
I made a combo chart where the x-axis is the date field. I have gaps in the date, but want my chart to reflect the gap. For example, I have big gaps in April, May, June, August, September, and October....
- 850
1
vote
0
answers
36
views
Google Sheets Area Graph(s)
I need (want) to create a Google Sheets Area Graph (Chart).
The Graph/Chart will represent "Date"s.
I need the Xaxis to be the dates (as days) between these start and end dates:
01/27/2020, 4/25/2020 ...
1
vote
1
answer
335
views
How do I create a pie chart in google sheets without a category or two from my data?
I have a list of data, showing 4 items. Cats, dogs, giraffes, eggplant.
I want to create a pie chart in google sheets that shows the pie with just cats, dogs, and giraffes. I don't want to show the ...
- 263
2
votes
2
answers
4k
views
Google Sheets: Histogram of time data (axis numbering)
I've tried making a histogram of my data, which looks like so:
12:00:02 PM
3:00:00 PM
12:30:00 PM
12:30:00 PM
2:00:00 PM
3:00:00 AM
…
I highlighted the data and selected insert > chart > ...
- 123
0
votes
1
answer
2k
views
Google Sheets: Fill out dates and replace blank cells with zeroes
I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable:
I think there are two reasons for this:
Not all dates have values associated with them, and ...
- 3
9
votes
3
answers
24k
views
How to reduce number of X axis labels?
I have a chart with dates along the X axis, but the chart displays them quite close together, producing a rather ugly graph. How might I reduce the number of visible labels to increase the readability ...
- 193
1
vote
1
answer
2k
views
How do you interpolate data in a horizontal range that's non-linear?
I've been told what I'm hoping to do is called 'spline interpolation'.
I've imported monthly youtube channel viewership figures from google API. And I've layed out the dates and views in a horizontal ...
- 11
0
votes
1
answer
1k
views
Stacking time series in Google Sheet Combo chart
I can approximate a stacked time-series plot using the Combo chart option in Google Sheets:
But it's not quite a "real" time series plot because the temporal gaps are not represented. Compare to this ...
- 101
2
votes
0
answers
1k
views
How can I create a violin plot in Google Spreadsheets?
How can I create a violin plot in Google Spreadsheets?
Example of violin plot:
- 17.3k
2
votes
1
answer
133
views
Color or group the same kind of data in a Google Sheet graph
I have the following data:
| Test Combination | C-Score | Memory | Reasoning | Verbal |
|------------------|---------|--------|-----------|--------|
| ABCD | 13.70 | 10.51 | 13.04 |...
- 23
2
votes
0
answers
83
views
Google Sheets: move a chart and still have it update from original data/arrays?
Can you move or copy a chart in Google Sheets into another EXISTING sheet and have it still update form the original data arrays?
I know you can move a chart into its own sheet, but I'm looking to ...
- 21
9
votes
3
answers
26k
views
How to use "aggregate" chart feature on Google Sheets
Line graphs and most other types in Google Sheets have a checkbox for "aggregate" in the setup tab. I've tried looking through the instructions but I can't find any documentation on how to use this ...
- 246
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
1
vote
1
answer
53
views
Visualize Data that updates dynamically
TLDR: How can I create a bar chart that updates the x-axis daily? The end goal is to have a chart that shows a side by side comparison of goal completions performance for each source of traffic. Here ...
2
votes
1
answer
2k
views
Create a Google Sheets graph with multiple lines in the same chart
I have data that looks like this:
Name X Y
Bob 0 15
Bob 3 20
Bill 0 24
Bill 5 30
And so on. Basically I want to have a line for Bob, a line for Bill, etc. With X as the X-...
- 121
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
3
votes
1
answer
312
views
Struggling to Generate Chart From Existing Data
This question is specific to Google Sheets—hopefully I’m in the right place.
https://docs.google.com/spreadsheets/d/161rtpjNK5363-U6y6MZYzqOIx7CQBCHDWInBXFtZYIg/edit?usp=sharing
As you’ll see above, ...
- 131
1
vote
1
answer
23
views
How to Change Agregated Data to Continuous
I would like to change the following two graphs in this link here
Problem 1
Under the chemistry and physics tab I have a graph like this:
Which is an agregate data set, but as you can tell the x-...
- 113
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
1
vote
1
answer
3k
views
Google Sheets Scatter chart: multiple data points at same X location
I have a dataset where I have on each row data associated with an item that has a name (alpha, beta, gamma in the example), as follows:
I now want to create a scatter plot where the X axis ...
- 111
0
votes
1
answer
1k
views
Unable to change Google Sheets data point format without changing other data points
I am trying to ensure that each bar in a horizontal bar chart in Google Sheets has its own unique color. Conventional wisdom seems to entail either
select the chart --> left-click on the bar -->...
- 425
-1
votes
1
answer
27
views
Process visualization based on data
I am trying to use a Google spreadsheet to visualize a customer journey.
I am trying to create the following graphic:
I have created the following example spreadsheet:
https://docs.google.com/...
- 199
1
vote
1
answer
217
views
Google Sheets time sorting chart [closed]
I have a MailChimp data export in google sheets and I want to create some charts that can show the best time of day/day of the week based on my data for our mail outs when compared to open rate (%). I ...
Dave Kempton
2
votes
1
answer
804
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
1
vote
2
answers
2k
views
How to preserve colors of each series from changing when inserting new data in Chart Editor?
This issue occurs in every chart type. As an example, I have a pie chart created from a long table of data where each column is assigned a specific text color, so each slice of the pie corresponds to ...
- 11
5
votes
2
answers
8k
views
Does Google Sheets allow moving a chart to its own sheet?
I know that Google Sheets used to allow moving a chart to its own worksheet so that nothing else is in that sheet. All the instructions I've found for how to do so are no longer relevant to the most ...
- 163
0
votes
1
answer
20
views
How do I turn a SQL database downloaded table into a Google Sheets multi-line chart?
I want to turn this table (comes from an SQL database)
...into a line chart in Google Sheets that looks like this
- 175
0
votes
1
answer
188
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 ...
0
votes
1
answer
73
views
Bar Chart Merge 2 columns in a single bar
I have the following table, I want to generate a bar chart where for each year I can see a single bar, including both Cash and Credit.
Today I only see this:
Link here
- 101
0
votes
1
answer
211
views
Google sheet chart, wrong time format in chart
I have created a Google Sheet that collects a bunch of values in columns. One of these is a time value formatted hh:mm:ss AM/PM, obtained with the following formula:
=TIMEVALUE(SUBSTITUTE("April 28, ...
- 579
0
votes
1
answer
135
views
Sum of time in Google Sheets' chart
I tried to show a chart where the values are the sum of times. It looks ok in the spreadsheet with for example 19 hours and 25 hours but in the chart, the 19 is ok but the 25 is shown as 1. The format ...
