Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
212
questions
2
votes
1
answer
60
views
Making a bubble chart in Goggle Sheets for year-on-year comparison - ie year versus month?
I'd like to make a multi-series bubble chart from 17 years of sporadic data with Year on the Y axis and Month+Day on the X axis and the bubble size corresponding to each data point's value.
I've ...
1
vote
0
answers
19
views
Calculating multiple means and then putting them in a graph but more complicated [closed]
Me and my sister love playing the sims and we want to analyze how much each painting you can make will earn.
We made a spreadsheet containing the type of painting, the cost of the painting, the mood ...
0
votes
1
answer
26
views
How to add a secondary vertical axis to a timeline chart in Google Sheets?
I have a timeseries chat plotting two different series, see here: https://docs.google.com/spreadsheets/d/1TGoHPodslxw01PVf8Yp4SI15saedY8iID3FegJg6lmg/
I would like to have 2 different Y-axes, one for ...
2
votes
1
answer
70
views
Google Sheets stacked bar chart showing 1 extra value and legend
Consider this Google Sheet:
6/30/2020 1/1/2021 1/1/2022
Consultant 3 4 6
Manager 0 1 1
Administrator 0 0 1
When I ...
0
votes
1
answer
27
views
Create a Chart for Membership Data
Was wondering how to best set up data to create charts for memberships.
I want to create a chart that compares # of New Members vs. # of Cancelled members. In the data, I have one columns that ...
1
vote
1
answer
65
views
Time series plot with category names as text
Let us say I have data like this for a spend summary sheet:
Date
Amount
Category
03/31/2023
20.0
Food
03/31/2023
23.12
Coffee
03/31/2023
21.01
Movie
04/01/2023
10.0
Coffee
04/01/2023
12.0
Coffee
...
0
votes
0
answers
11
views
Google Sheets: stack week value into one month bar
For simplicity sake, let's say I have this data:
Mon $10
Tue $12
Wed $9
Thu $10
Mon $11
Tue $11
Wed $12
Thu $9
...
I want to create a stacked chart in Google Sheets.
In the first column (labelled ...
1
vote
1
answer
193
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 ...
0
votes
1
answer
120
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
2
answers
87
views
How to automatically plot multiple series from values in a column
In Google Sheets, I know I can plot multiple series into a chart by manually adding a series and selecting/specifying the source data for each series. But is it possible to use a third column to ...
1
vote
1
answer
797
views
Showing rounded integer values in a Pie Chart in Google Sheets without decimals (Pie Chart - Slicing Label does not work)
The proposed solution for the general question has been already asked here: How to change the values of a pie chart to absolute values instead of percentages in Google Sheets
But it doesn't work for ...
1
vote
1
answer
780
views
How to chart a sum of categorised values
I'm trying to figure out how to chart this in Google Sheets.
Each segment of the pie chart should be the sum of each different "Type", e.g. there should only be one pie segment per type.
I ...
1
vote
1
answer
112
views
How to Change Percentage Precision on Google Sheets Scatter Chart
I have made a scatter chart on Google Sheets from two columns of data. One column labeled "Pre-EO Remediation Rate" and one column labeled "Length of Pathway (Semesters)". A sample ...
1
vote
0
answers
18
views
Unlimited range for plot in Sheets
I would like to create a plot whose range extends as new columns of data are added.
I have read that dynamic named ranges are not available in Sheets, and that named ranges are not allowed in plot ...
1
vote
2
answers
581
views
Google sheets chart to compare two values every year
I'm trying to build a chart within google sheets to compare my portfolio contributions vs yearly allowed maximum limits. My data looks like the below. I'm not sure which chart to make use of to ...
0
votes
1
answer
902
views
Chart on Frozen Cells in Google Sheet
Is it possible to place a chart outside the scrollable part of a google sheet when some rows and columns are frozen. I tried removing the frozen panels first, creating the chart and freezing columns ...
1
vote
0
answers
150
views
How to prevent Google Sheets setting chart axis option "Treat Labels as Text" for imported xlsx?
I've imported an Excel spreadsheet containing a chart into Google Sheets.
Excel displays my axis like this:
After importing the xlsx into Google Sheets the Axis displays like this:
I can get Google ...
2
votes
1
answer
17
views
Google sheet trend chart help
Is there a way to display this years data like it is in this chart but have a cut off so the line doesn't drop to 0?
Please see attached image
Many thanks
0
votes
3
answers
95
views
Making a graph from data of one out every n lines
I have data that comes in batches of N values ("Y" values if you like) for a given index (or "X" value if you like). How to make N separate series in my graph for each entry of a ...
0
votes
1
answer
203
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 ...
0
votes
1
answer
92
views
Why do my data points end up in the wrong places in my graph?
So I am trying to insert a vertical line in my graph in Google Sheets, by following the solution given here:
https://stackoverflow.com/questions/58026200/add-a-vertical-line-to-google-sheet-line-chart
...
1
vote
1
answer
845
views
How can I show specific points in a smooth line curve on Google Sheets
I was able to create this graph
However, I want to know how I can have dots that represent the specific points, while still having this be a smooth curve.
0
votes
1
answer
66
views
Group occurrences and combine values for Line Chart
I want to create a chart that counts occurrences from two different columns which might not have the same values.
Here is a sample data:
Be aware that the unique values might not be the same in each ...
1
vote
0
answers
252
views
How can I plot points on a 1d number line in Google Sheets?
I'd like to create a 1-dimensional chart in Google Sheets. The chart effectively plots values on a number line like so:
A B C D E
|-------------O-------...
0
votes
0
answers
153
views
Stacked Bar Graphs with ‘Nested Data’ for two Y-Axis Categories
Re: Stacked Bar Graphs with ‘Nested Data’ for two Y-Axis Categories
Forgive me if I have a hard time articulating our need. I have two data sets that have the following content:
Number of Placements ...
0
votes
1
answer
31
views
How to combine cells of data in Googlesheet to a single/consolidate row and remove duplicates?
I'm trying to consolidate all the invoices that we get from the same contractor to a single row that will have the business name, all the memos/invoices for the week in one cell along with the added ...
-1
votes
1
answer
629
views
How can I change the min and max value of vertical axis in chart?
I want the vertical axis to range between 75 and 125. The min should be 75 and the max should be 125.
0 to 125 range is automatically generated.
The highest data point is 107 and the lowest data point ...
6
votes
1
answer
2k
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, ...
0
votes
1
answer
42
views
How to supply filtered series (data range) to chart?
I have a table with X-Y values for two types of measurements, I want to draw two graph lines on a chart for each of the type (without modification of data in the sheet)
x-values
y-values
type
0
5
A
...
0
votes
1
answer
28
views
Is there a way to track the frequency of a relationship between two columns?
I have two columns in a spread sheet where column A tracks about 100 different categories. In Column B, I have a formula that maps specific categories in Column A to one of 10 separate categories in ...
0
votes
1
answer
130
views
How to assign a name to a membership number vice versa?
I would like to learn what formula I can use to make my timesheet more efficient.
How to assign a membership number to a name vice versa? I need to add lesson hours to each membership daily and ...
1
vote
1
answer
1k
views
Google Sheets: how to reference a range of cells for charts using a formula?
I'm trying to make a chart always take the range from the first 8 cells within a column without updating the range when a new row is added above the range. You could use something like "=INDIRECT(...
1
vote
2
answers
2k
views
Google Sheet: is it possible to make a chart's vertical axis' Min and Max values automatically adjust according to the values in the dataset?
I want to have my chart, which displays a range of data that updates periodically, to represent the changes across sampled values in a more zoomed-in form by having the minimum value of the vertical ...
0
votes
1
answer
209
views
How to keep my chart unchanged when deleting rows from data source?
Could anyone kindly advise how to keep my sample chart unchanged after deleting the unnecessary Row 2?
I have a Google Sheet that contains over 50 charts whose data source is within only one big data ...
0
votes
1
answer
1k
views
Getting error while using inlineImages
I am always getting error while using inlineImages.
"Error
Exception: Invalid argument: inlineImages"
Below is my code:
var blob = Charts.newTableChart()
.setDataTable(table.build())
...
-1
votes
1
answer
657
views
Google Sheets Pie Graph Aggregation Merges Completely Different Categories
I've been trying to make a basic chart in google sheets that puts together the time taken for various activities to make a pie chart. Since the same activities appear multiple times I need to ...
0
votes
1
answer
59
views
How do I chart timeseries data organized by one of the columns?
Here's what seems to be a simple common thing in excel/sheets that I can't seem to be able to google in the right way. three columns: timestamp, email, things_done.
I want a chart with time as the X ...
0
votes
1
answer
97
views
Plotting gigantic values + smaller values on the same Google Sheets chart?
I'm trying to plot a chart that includes one data set in billions, another in millions, and a third in thousands.
What is the most efficient/elegant way to do this using google sheets without the ...
0
votes
1
answer
854
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 ...
3
votes
0
answers
455
views
How do I specify a consistent interval for a date-range axis in a Google Sheet Chart
I have a Google Sheet with a set of deposits and withdrawls and the running balance. I have added a chart to the sheet, so I can visualize what the balance has been over time and when deposits or ...
1
vote
0
answers
303
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
0
answers
52
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 ...
2
votes
1
answer
10k
views
How to overlay two charts?
In Google Sheets, I need two sets to data to appear on the same chart. One needs to be a scatter charts and the other needs to be a line chart. Both sets of data have the same x and y axis data / ...
2
votes
1
answer
341
views
How do I extract specific value from a single cell on Google Sheets
I'd like to get respective data into each cell without the key and punctuations. Each cell must display only the value extracted from the properties column.
I've tried to go to Data>split text to ...
0
votes
1
answer
616
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
0
answers
1k
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
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 |
+----+---+---+----+
| ...
0
votes
0
answers
22
views
Chart with multiple groups [duplicate]
I got the following table on Google Sheets.
I want the first column to represent the groups in x axis.
The 2nd column is supposed to be the a group in a certain x value
lets say I have:
8 3 22
8 4 ...
1
vote
0
answers
646
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
1
answer
244
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?
...