Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
201
questions
0
votes
3
answers
30
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 ...
- 103
0
votes
1
answer
28
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
30
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
...
0
votes
1
answer
41
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.
- 101
0
votes
1
answer
25
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
0
votes
0
answers
33
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-------...
- 201
0
votes
0
answers
43
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
17
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 ...
0
votes
0
answers
22
views
Define the x axis in a chart using two ranges
I have this data in Google Sheets,
x1 y1 x2 y2
0 0 9 0
1 2 7 -4
2 2 5 -4
3 0 3 0
and I'm trying to produce a graph (the y-axis is inverted, ...
- 111
0
votes
1
answer
19
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 ...
0
votes
0
answers
16
views
Google Sheets– Scatter chart comparing two variables
I'm trying to compare two different variables, one as x and one as y, for 30 different countries on the same graph. Basically, I'm trying to get it to look like the graph below, only with several ...
- 1
0
votes
0
answers
84
views
How do I change textStyle of labels in radar chart?
I'm making a radar chart using Google Apps Script and I don't know how to change the font size of the "labels" (see the picture). So far I've tried hAxis, ticks, legend and none of them ...
- 3
0
votes
1
answer
63
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, ...
- 101
0
votes
0
answers
11
views
Pivoting 3-dimensional data
I have this 3-dimensional data and would like to have a chart to
view each person's data from their category (Approach-Meet-Master).
Any help?
Approach Meet Master
UA1 ...
- 1
0
votes
0
answers
19
views
Line Chart with series dynamically generated from cell values
I have the following data:
https://docs.google.com/spreadsheets/d/1odEoSCiz897B3Qm_GCOXQkxyE5JP504blizhDkC4y4o/edit?usp=sharing
I wanted a line chart where the x-axis was the 'date' from column A and ...
- 101
0
votes
1
answer
14
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
20
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
9
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
0
votes
0
answers
478
views
How to reverse the y-axis in google sheets when the y-axis is time of day?
So I'm trying to make a Marey graph, and I have it mostly figured out, but I can't figure out how to get it so that 12 AM is followed by 1 AM and so on, currently it starts at 12 AM, then goes to 11 ...
0
votes
1
answer
104
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(...
- 5
0
votes
2
answers
434
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 ...
- 5
0
votes
1
answer
29
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
0
answers
15
views
Sheets histogram not displaying bucket values
Given a series of values (range:1->7.989000E-11) to create a histogram. Horizontal max set to .0000001 (with option selected Allow bounds to hide data). I try to view the ranges of the various ...
- 99
0
votes
1
answer
63
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
195
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
37
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
36
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
408
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
2
votes
0
answers
65
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 ...
- 21
1
vote
0
answers
165
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
40
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
0
votes
1
answer
3k
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
248
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
276
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
442
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?
- 550
0
votes
1
answer
555
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
20
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
1
vote
0
answers
235
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?
- 111
0
votes
1
answer
80
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?
...
- 8,468
-1
votes
2
answers
59
views
Add % sign in Data Labels Google Sheets [closed]
I have a simple chart in Google Sheets. Currently, the data labels are just numbers. I want to append a % sign infront of each value. How can I do so?
https://docs.google.com/spreadsheets/d/1wyubPje-e-...
- 99
0
votes
1
answer
75
views
Copy from individual cell in Google Sheets Table Chart
I'm using appscript to build and insert a table chart into a sheet when a button has been pushed.
var chart = sheet.newChart()
.setChartType(Charts.ChartType.TABLE)
.addRange(outrange2)
.setPosition(2,...
0
votes
1
answer
49
views
How to make time series chart, where all rows are labelled and dates are not unique?
Say I have some data like so
| Month | Count | Type | | |
|-------|-------|------|--- |--- |
| 1 | 2 | A | | |
| 1 | 3 | B | | |
| 2 | 1 | A | | ...
1
vote
1
answer
467
views
Google Sheets: aggregate and extrapolate irregular data over time
I have a list in which I now-and-then (no fixed interval) enter the available budget.
Most of all I want to extrapolate this to a future trend of the coming 10 years. (no rocket science, more of an ...
- 115
2
votes
0
answers
18
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?
- 121
1
vote
0
answers
615
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 ...
- 111
1
vote
0
answers
354
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?
- 11
1
vote
0
answers
55
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 ...
- 111
1
vote
0
answers
13
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 ...
- 11
1
vote
1
answer
61
views
Google Sheets graph jump by 1 on the horizontal axis
How can I change the graph’s horizontal axis to show a jump by 1 instead of 2?
- 11
1
vote
1
answer
5k
views
How do I format the horizontal axis labels on a Google Sheets scatter plot?
The settings for the vertical axis on a Google Sheets scatter plot provide an option for selecting or customizing a format for the labels, but no corresponding option is provided for the horizontal ...
- 550