Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
189
questions
0
votes
1answer
30 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
0answers
5 views
Show label when hovering over point in diagram
My chart is quite crowded but I need to be able to look up the manual labels assigned to each point. Is there a way to make Google spreadsheet show the manual label upon hovering over the point with ...
0
votes
0answers
16 views
Generate a line chart with each player's running score (competition tracker) [closed]
I asked this question on https://www.reddit.com/r/excel/comments/mikwvz/competition_tracker_create_publicly_accessible/?utm_source=share&utm_medium=web2x&context=3, but didn't get an ...
0
votes
0answers
6 views
Add more numbers in Vertical axis
Ideally, I'd like it to have percentages of 10. 0% - 10% - 20% - 30%, etc.
But I'm not finding a way to customize this.
Can anyone help?
0
votes
1answer
18 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 ...
-1
votes
0answers
11 views
How to put a filter permanently in Google Sheets even when close and open the Spreadsheet?
I have a filter to sort the dates to show the last 3 months that I use for some charts.
However, I have a lot of data and the time for the filter works correctly is too long and I have to set the ...
1
vote
0answers
12 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 ...
0
votes
0answers
10 views
Creating graphs from own formula
We are all familiar with the Y=mx+b
Now I have the following values that I want to use in this formula to create a graph in Google Sheets:
m = slope
k = exponent
b = y-intercept (vertical shift)
c = x-...
0
votes
0answers
14 views
How to combine two data points into one on a Google Sheets line chart?
I am trying to make a Google Sheets line chart. Why does this not work as a data range?
A31:A69,A71:A94,D31:D68,=SUM(D69:D70),D71:D94
X-axis = column A (date)
Y-axis = column D (dollars, numeric)
Only ...
1
vote
0answers
71 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://...
0
votes
0answers
23 views
Always use last completed row for pie chart
I have a Sheet onto which I add a line every week to record certain numbers in various category (columns).
I would like to have a Pie chart display the current status of those categories. This means ...
1
vote
0answers
21 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 ...
0
votes
1answer
96 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
1answer
88 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
1answer
49 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
0answers
28 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
1answer
30 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
0answers
9 views
How do I get uniform spacing for x-axis labels that are numerical values in Google Sheets?
I have a Google sheets line chart and would like to use a series as the labels for the x-axis in which the elements are even spaced along the x-axis; however the values in that series
1.1 2.1 3.1 4.1 ...
0
votes
0answers
19 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 ...
0
votes
0answers
33 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
1answer
26 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?
...
0
votes
0answers
12 views
How to only show Monthly results in Google Sheets Graph
Im trying to make this graph to only show the monthly results, but the specified Dates are also showing on it and I fear I will end up with a clunky, ugly graph. Ive tried changing the data to B2,B8,...
-1
votes
2answers
20 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-...
0
votes
1answer
54 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
1answer
25 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
1answer
224 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 ...
0
votes
0answers
18 views
Can't get chart to display weeks from specified day
I can't for the life of me get my chart to display every Monday (starting from 13/07, instead it displays every Sunday (starting with 12/07).The chart also starts with 6 data points (minor lines) and ...
2
votes
0answers
15 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?
0
votes
0answers
11 views
Google Sheets chart only shows first ~250 rows?
I have a stacked area chart with an x-axis from B8:B350 and two series from C8:C350 and D8:D350 (so data range B8:D350) but the data only displays the first ~250 rows which is September to May. Any ...
1
vote
0answers
474 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 ...
0
votes
0answers
15 views
How do I make a chart based on labeled values in Google Sheets?
I have a simple data set with nine values in Google Sheets. (Link here, screenshot follows.)
Some questions about charts (Mockup at bottom):
I can concatenate Columns A and B into a new column ...
1
vote
0answers
15 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?
1
vote
0answers
26 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
0answers
6 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
1answer
33 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?
1
vote
1answer
1k 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 ...
2
votes
1answer
87 views
Bar chart that counts rows google sheets / Pandemic-like chart
I have a google form linked to a google sheet (so every time somenone fills the form, a new row is created). I would like to make a chart that count the number of rows each day. In the example shown ...
0
votes
0answers
12 views
Plotting a chart when header is not immediately above first data point
Say I have these the following data:
A B C
1 Yes No
2 8/10/12 56 17
3 8/11/12 44 69
4 8/12/12 71 15
5 8/13/12 56 44
6 8/14/12 ...
0
votes
1answer
36 views
How to create a chart in Google Sheets for yearly value growth when the data is separated by quarters?
How to create a chart in Google Sheets for yearly value growth when the data is separated by quarters?
For
2
votes
1answer
28 views
Getting a line graph to begin at the Y-axis?
Really simple question that's driving me nuts for a while. How do I get my line graph in Google Sheets to begin at the Y axis - i.e. so there isn't a gap before the January 2020 date?
I've been ...
0
votes
0answers
15 views
Visualize time events, one line per day
In Google Sheets, I have a list of events like this ("Date time" format):
4/13/2020 11:11:32
4/13/2020 11:40:54
4/13/2020 12:16:28
4/13/2020 13:07:01
4/14/2020 11:33:26
4/14/2020 12:04:39
4/14/2020 ...
0
votes
1answer
22 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 ...
0
votes
2answers
4k views
How to rename a series in Google Sheets chart?
By default, a Google Sheets chart will use the first row as the the name of the Series. But if you are selecting a range in the middle of the table (for example, rows 38-100), then you can't use the ...
1
vote
0answers
11 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!
2
votes
1answer
758 views
Missing dates in time series are not showing blanks in x-axis
I made a combo chart where the x-axis is the date field. I have gaps in the date, but want my chart to reflect the gap. For example, I have big gaps in April, May, June, August, September, and October....
1
vote
0answers
19 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
1answer
47 views
How do I create a pie chart in google sheets without a category or two from my data?
I have a list of data, showing 4 items. Cats, dogs, giraffes, eggplant.
I want to create a pie chart in google sheets that shows the pie with just cats, dogs, and giraffes. I don't want to show the ...
1
vote
0answers
264 views
Google Sheets: Histogram of time data (axis numbering)
I've tried making a histogram of my data, which looks like so:
12:00:02 PM
3:00:00 PM
12:30:00 PM
12:30:00 PM
2:00:00 PM
3:00:00 AM
…
I highlighted the data and selected insert > chart > ...
0
votes
1answer
2k views
Google Sheets: Fill out dates and replace blank cells with zeroes
I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable:
I think there are two reasons for this:
Not all dates have values associated with them, and ...
4
votes
1answer
8k views
How to reduce number of X axis labels?
I have a chart with dates along the X axis, but the chart displays them quite close together, producing a rather ugly graph. How might I reduce the number of visible labels to increase the readability ...
