Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
2
votes
1
answer
36
views
chart select data: there are more items than can fit in the menu
I have time series data with at least 250 data points. I graph the data with a Sheets Line Chart. I'd like to add some data points with labels to the graph via the Add Select Data Point option.
...
- 21
0
votes
0
answers
9
views
Google Sheet Data and Pie Chart [duplicate]
I need to show on a pie chart the data in Column B as a % of data in Column A How can I do that?
The chart calculates the data in Column A as a % of the total sum of column A.
- 1
0
votes
0
answers
11
views
Mulitlevel axis [duplicate]
I am looking for any idea on how to make a multilevel axis on Google Sheet like we can do on Excel so having on X Axis the year AND the month :
- 1
3
votes
1
answer
90
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 ...
- 31
1
vote
0
answers
20
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 ...
- 11
0
votes
1
answer
93
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 ...
- 103
2
votes
1
answer
133
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 ...
- 449
0
votes
1
answer
30
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
1
vote
1
answer
113
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
...
- 113
0
votes
0
answers
12
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
518
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
227
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
271
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 ...
- 101
1
vote
1
answer
1k
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 ...
- 361
1
vote
1
answer
1k
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 ...
- 113
1
vote
1
answer
365
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 ...
- 13
1
vote
0
answers
19
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 ...
- 41
1
vote
2
answers
1k
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 ...
- 111
0
votes
1
answer
1k
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
218
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 ...
- 63
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
- 31
0
votes
3
answers
161
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 ...
- 123
0
votes
1
answer
257
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
1
answer
119
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
1k
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.
- 111
0
votes
1
answer
89
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 ...
- 101
1
vote
0
answers
331
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-------...
- 251
0
votes
0
answers
160
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 ...
-1
votes
1
answer
774
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 ...
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
0
votes
1
answer
58
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
...
- 103
0
votes
1
answer
37
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
148
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
1
vote
1
answer
2k
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(...
- 135
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 ...
- 135
0
votes
1
answer
258
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 ...
- 1
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
733
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 ...
- 11
0
votes
1
answer
148
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 ...
- 3
0
votes
1
answer
945
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 ...
- 105
3
votes
0
answers
595
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 ...
- 31
1
vote
0
answers
357
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://...
- 109
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 ...
- 11
3
votes
1
answer
13k
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
384
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 ...
- 21
0
votes
1
answer
683
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',...
- 1
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?
- 660
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
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 ...
- 13