Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
58
questions with no upvoted or accepted answers
3
votes
0
answers
607
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 ...
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, ...
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 ...
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 ...
2
votes
1
answer
39
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.
...
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
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?
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:
2
votes
0
answers
84
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 ...
2
votes
0
answers
520
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 ...
2
votes
0
answers
629
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 (...
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 ...
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 ...
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 ...
1
vote
0
answers
221
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 ...
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.
1
vote
0
answers
334
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-------...
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 ...
1
vote
0
answers
362
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 ...
1
vote
0
answers
754
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?
1
vote
0
answers
788
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
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 ...
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 ...
1
vote
1
answer
152
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 ...
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!
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
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 ...
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 ...
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 ...
1
vote
0
answers
29
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
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 ...
1
vote
1
answer
115
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 ...
1
vote
1
answer
160
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('...
0
votes
1
answer
99
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 ...
0
votes
1
answer
32
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 ...
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
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 ...
0
votes
1
answer
264
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
0
answers
162
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
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 ...
0
votes
1
answer
261
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())
....
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
687
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
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 ...
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 -->...
0
votes
1
answer
194
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 ...