Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
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, ...
- 11
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',...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
3
votes
1
answer
161
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 ...
CommunityBot
- 1
1
vote
1
answer
2k
views
How to create a 3 column chart in Google Sheets with one numerical column and two text columns with customization?
Consider this data:
Food
Quantity
Type
Apple
3
Fruit
Spinach
1
Vegetable
Mango
2
Fruit
Almond
1
Nut
I want to convert this to a chart with X and Y axis being the food name and the quantity. But ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
2
votes
1
answer
33
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.
...
0
votes
1
answer
92
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 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())
....
CommunityBot
- 1
0
votes
1
answer
255
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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.
- 44.6k
1
vote
1
answer
111
views
Aggregate data with Sheets pivot table or graph
Please have a look at this google sheet here.
It has a pivot table with 3 columns:
A period (for example: 2016/01), a category and a number. I would like to do a chart that looks like this:
For ...
CommunityBot
- 1
0
votes
1
answer
42
views
Comparison Column Chart
I'm trying to make a chart in Google Sheets to compare how much two people have paid towards something. What I'm looking for is the chart to have several cost categories (groceries, dining out, pets, ...
CommunityBot
- 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
0
votes
1
answer
255
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 ...
CommunityBot
- 1
0
votes
1
answer
1k
views
Google Sheets table of data wont create graph accurately?
So I am trying to convert some data into a scatter plot using Google Sheets. I have 2 problems:
When I try and order the x and y so that the graph has x data on x and y on y it inverts it. May this ...
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 ...
CommunityBot
- 1
0
votes
1
answer
1k
views
How to group certain data in a chart in Google Sheets
I'm creating a chart of a number of items (website traffic sources) and want to find a way to merge any rows that contain 'Facebook' in the chart.
Here's the raw data:
(direct) 67
192.com ...
CommunityBot
- 1
0
votes
1
answer
186
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 ...
CommunityBot
- 1
3
votes
1
answer
5k
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 -->...
CommunityBot
- 1
3
votes
1
answer
89
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 ...
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
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
0
votes
3
answers
3k
views
Multiple columns as one in an Google Sheets chart
I have a Google Sheet tracking data over days, logging data at different times during the day, example:
Is there any way that I can have this data represented in a chart as one continuous line ...
CommunityBot
- 1
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.
CommunityBot
- 1
1
vote
1
answer
147
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 ...
CommunityBot
- 1
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
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?
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 ...
CommunityBot
- 1
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, ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
1
vote
1
answer
158
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('...
CommunityBot
- 1
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 |
+----+---+---+----+
| ...
CommunityBot
- 1
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:
1
vote
1
answer
512
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 ...
- 3,381
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
CommunityBot
- 1
2
votes
2
answers
832
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 ...
CommunityBot
- 1
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 ...
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 ...
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
...
- 13.2k
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 ...
0
votes
1
answer
226
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 ...
- 3,381
0
votes
2
answers
267
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