Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
60
questions with no upvoted or accepted answers
12
votes
2answers
4k views
Statically positioned chart (ignore scroll)
I have a Google Sheets document with four columns of data. I have a chart on the right side. When you scroll down to see all the data, the chart scrolls up off the screen.
Is there a way to make it ...
3
votes
0answers
5k views
Showing percentages in google sheet bar chart
It looks like bar charts in Google Sheets won't support percentages.
Is this correct?
If so, how would a change the populating query that currently returns "count of"?
A single cell used as the ...
3
votes
1answer
123 views
Selecting a single column from all rows for chart range
I want to specify a certain column from all rows (omitting the first few) to be the range for my chart. Currently I input this to specify the range: L6:L (note: this automatically changes to L6:L20 ...
2
votes
0answers
15 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?
2
votes
0answers
211 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:
2
votes
1answer
300 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, ...
2
votes
1answer
3k views
Can I precisely position charts in Google Sheets?
I am using Google Sheets to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report.
In this spreadsheet, I ...
1
vote
0answers
44 views
Create circle packing charts in Google Sheets
I am trying to find a way to add a circle packing chart to a Google Sheet, using the data in a Google Sheet as its data source.
The only possibility I have found is this from DHUMANITIES
http://...
1
vote
0answers
18 views
Capturing events on embedded charts within Google Sheets
I am trying to embedded column chart in Google sheets and would like to capture events like which column was clicked, then use the info to highlight certain cells. Is that even possible in embedded ...
1
vote
0answers
228 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 ...
1
vote
0answers
14 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?
1
vote
0answers
23 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 ...
1
vote
0answers
6 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 ...
1
vote
0answers
11 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!
1
vote
0answers
19 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
0answers
20 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 ...
1
vote
1answer
38 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 ...
1
vote
0answers
545 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 ...
1
vote
1answer
46 views
Google Sheets time sorting chart
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 ...
1
vote
1answer
349 views
Compare dates from two years in a graph when dates not identical in Google Sheets
I can’t figure out how to compare two data sets with date intervals form each year.
Only the start and end date are the same days, the rest is spread over the period. And there can be more points in ...
1
vote
0answers
15 views
Dynamic Sized Image in Google Sheets For Printing Based On Cell
I've made a calculator with Google Sheets to make it easier for Olympic shooters to train at home. The data that it produces is very helpful, but I would like to make it easier for the users to print ...
1
vote
0answers
356 views
How to align one axis in a two axis chart
I want to align my right vertical scale with my left vertical scale so both have the 0 at the same height.
I have this:
And I want this (I've done it manually but it's not perfect, look how both 0s ...
1
vote
1answer
125 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('...
1
vote
0answers
444 views
Chart in Google Sheets is duplicating data labels
I'm using Google Sheets and a triggered Apps Script function to create a waterfall chart. Basically this involves breaking apart each value into a base (either visible or invisible), a falling value (...
0
votes
0answers
7 views
How to combine two data points into one on a Google Sheets line chart?
I am trying to make a Google Sheets line chart. Why does this not work as a data range?
A31:A69,A71:A94,D31:D68,=SUM(D69:D70),D71:D94
X-axis = column A (date)
Y-axis = column D (dollars, numeric)
Only ...
0
votes
0answers
18 views
Always use last completed row for pie chart
I have a Sheet onto which I add a line every week to record certain numbers in various category (columns).
I would like to have a Pie chart display the current status of those categories. This means ...
0
votes
1answer
28 views
Google Sheets - Filtering Chart Data with Checkboxes
In Google Sheets, I'm making a 'workbook' that keeps track of inventory in a shop. There are 3 sheets in the workbook.
The first one is the raw data which is 'Item Name', 'Initial Stock', 'Stock Used',...
0
votes
0answers
11 views
How do I set the font for a published Google Sheets chart?
Google Sheets supports the publishing of interactive charts, but the resulting charts do not use the font set in the sheet.
How do I set the font for a published Google Sheets chart?
0
votes
1answer
22 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 |
+----+---+---+----+
| ...
0
votes
0answers
7 views
How do I get uniform spacing for x-axis labels that are numerical values in Google Sheets?
I have a Google sheets line chart and would like to use a series as the labels for the x-axis in which the elements are even spaced along the x-axis; however the values in that series
1.1 2.1 3.1 4.1 ...
0
votes
0answers
23 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?
0
votes
0answers
12 views
How to only show Monthly results in Google Sheets Graph
Im trying to make this graph to only show the monthly results, but the specified Dates are also showing on it and I fear I will end up with a clunky, ugly graph. Ive tried changing the data to B2,B8,...
0
votes
0answers
18 views
Can't get chart to display weeks from specified day
I can't for the life of me get my chart to display every Monday (starting from 13/07, instead it displays every Sunday (starting with 12/07).The chart also starts with 6 data points (minor lines) and ...
0
votes
0answers
11 views
Google Sheets chart only shows first ~250 rows?
I have a stacked area chart with an x-axis from B8:B350 and two series from C8:C350 and D8:D350 (so data range B8:D350) but the data only displays the first ~250 rows which is September to May. Any ...
0
votes
0answers
12 views
How do I make a chart based on labeled values in Google Sheets?
I have a simple data set with nine values in Google Sheets. (Link here, screenshot follows.)
Some questions about charts (Mockup at bottom):
I can concatenate Columns A and B into a new column ...
0
votes
0answers
12 views
Plotting a chart when header is not immediately above first data point
Say I have these the following data:
A B C
1 Yes No
2 8/10/12 56 17
3 8/11/12 44 69
4 8/12/12 71 15
5 8/13/12 56 44
6 8/14/12 ...
0
votes
0answers
14 views
Visualize time events, one line per day
In Google Sheets, I have a list of events like this ("Date time" format):
4/13/2020 11:11:32
4/13/2020 11:40:54
4/13/2020 12:16:28
4/13/2020 13:07:01
4/14/2020 11:33:26
4/14/2020 12:04:39
4/14/2020 ...
0
votes
1answer
21 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 ...
0
votes
1answer
1k 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 ...
0
votes
0answers
15 views
How to make one of lines continuous in Google Sheets?
I drew fitting plot in Google Sheet, but both series were depicted by separate dots
How to make red series continuous?
If I choose edit, I get only settings for dots
0
votes
0answers
27 views
How to create chart until today's date, automatically, every day?
On a row from left to write there are dates (daily). Manually written, but automatically populated.
On another row, there are formulated numbers (formulated for each date).
The chart gets those ...
0
votes
0answers
27 views
Creating a horizontal decision tree in Google Sheets - Can the one flip the default one?
I want to create a horizontal decision tree in Google Sheets - the default one is vertical - moving from top to down, I want mine to be like a decision tree from left to right branching out.
How can ...
0
votes
0answers
11 views
Finding a cell value based on row and column
I have a little problem that might not be solved just with formulas. And I am not so advanced in JavaScript yet.
I have a list of products, our salesmen, customers and time when and how much the are ...
0
votes
0answers
168 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 > ...
0
votes
1answer
1k 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 ...
0
votes
1answer
572 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 ...
0
votes
1answer
249 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 ...
0
votes
1answer
959 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 ...
0
votes
1answer
329 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 -->...
0
votes
1answer
18 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/...