Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
3 votes
3 answers
24k views

Why don't Google Sheets graphs lay out my points correcty?

When I try to make a simple graph of some points in a Google Sheets said points do not end up where I want them to in the graph. Using data like this I expect a straight line in my graph: col A col ...
Arlaharen's user avatar
  • 1,444
3 votes
1 answer
14k 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 / ...
StackOverflowNewbie's user avatar
3 votes
1 answer
7k 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 ...
orome's user avatar
  • 700
3 votes
1 answer
3k views

Google Sheets Problem with Chart Axis

I have a Google Sheet with a some data that I need to chart. The horizontal axis should be a list of dates. When I plot the chart, though, it's inserting dates that aren't part of the data set. For ...
Pete's user avatar
  • 133
3 votes
1 answer
4k views

How to share with others a poll's result as a chart?

I've created a form on Google Drive. The form is public, anyone can see it and respond to it. I would like also to provide a link to the data gathered by the form, however I would like to provide the ...
Wodzu's user avatar
  • 141
3 votes
1 answer
1k views

Why is "access denied" to multisheet charts in published Google Sheets?

I can successfully include a chart based on a single sheet, but as soon as I combine ranges from multiple sheets, I get an access denied error. Example spreadsheet Published spreadsheet What am I ...
antony.trupe's user avatar
3 votes
1 answer
136 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 ...
flyhigher's user avatar
3 votes
1 answer
2k views

How do I set the vertical axis to powers of 10?

For my Google sheets chart I have set the vertical axis to a logarithmic scale. I would prefer this to be displayed as a powers of 10, is this possible? What I get: What I want:
Morgoth's user avatar
  • 331
3 votes
1 answer
3k views

Google Sheets Scatter plot with multiple data sets and independent axis

I want to create a scatter plot in Google Sheets to display several sets of x and y coordinates, such that every five sets are a different color and a different element on the legend. Is this even ...
CluelessButCurious's user avatar
3 votes
1 answer
717 views

Creating a chart with independently indexed series

I have a data series that looks like this (bigger data set but that's accurate): 0 317.59 1.4 317.59 1.5 408.77 2.15 408.77 2.25 440.46 2.98 440.46 3.08 ...
RCIX's user avatar
  • 453
3 votes
0 answers
699 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 ...
Todd Powers's user avatar
3 votes
1 answer
315 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, ...
csswizardry's user avatar
3 votes
1 answer
3k views

A scatter plot with given labels and x- and y- axis values

I'm trying to create a scatter-plot with: Labels in column A X-axis values in column B Y-axis values in column C Both column B and C have non-integer values. I've tried fiddling with all the ...
RootFAIL's user avatar
3 votes
1 answer
25k views

Add additional lines to Google Sheets Line chart

I'm having some issues adding simple lines to a line chart on Google Sheets. I have a line chart using Table A, has ten X and Y values, X values are dates, Y values are a number, simple line chart. I ...
J. Doe123's user avatar
3 votes
1 answer
169 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 ...
Shazz's user avatar
  • 131
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 ...
user15571's user avatar
2 votes
1 answer
3k views

Google sheets: chart with steps of constant height change, variable width

I want to draw a chart in Google Sheets to represent the position of a stepper motor. As the motor speeds up, it steps more quickly. But in this case, it can only ever move one step at a time. So if I ...
Jodes's user avatar
  • 439
2 votes
1 answer
13k views

Add headers to Google Spreadsheet chart [closed]

I have a chart in a spreadsheet. If I click on it and select 'advanced edit' > Start, it offers to 'Use row 12 as headers'. How can I use a different row for the header names? My data has rows for the ...
spiderplant0's user avatar
2 votes
1 answer
393 views

How to make a bold sparkline in Google Sheets?

Is it possible to thicken the line graph shown when using the formula =SPARKLINE(L4:L)?
orschiro's user avatar
  • 5,488
2 votes
3 answers
2k views

How can I make Google Sheets tell me how many of each date are in a column?

I have a column in my spreadsheet that contains only Date values, like: 2014-05-17 2014-06-19 2014-07-16 2014-07-16 2014-07-21 2014-07-21 2014-07-21 2014-07-21 2014-07-21 2014-06-17 2014-06-24 2014-...
Ky -'s user avatar
  • 121
2 votes
2 answers
3k views

Is there a way to count how many entries in a given column have a particular value?

I have a spreadsheet which keeps track of duels between two players in a game. Each row has the number of the match and the winner, given by their initial, X or Y. I want to know if it's possible to ...
victoriah's user avatar
  • 1,187
2 votes
2 answers
5k 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 > ...
ions me's user avatar
  • 123
2 votes
1 answer
1k views

Graphing two lines in Google Sheets based on values in first column

I'm trying to create two lines on the same graph, with one being 'Line A' based on Data labeled 'A' and 'Line B' based on B. The X-axis would be the date and would expand over time as more entries ...
zzzjoshzzz's user avatar
2 votes
1 answer
438 views

How to use Google Spreadsheets to chart completed tasks using time series graph?

I have the following columns in Google spreadsheet Date and Completed Tasks Sample data includes May 17, 2016 3 May 18, 2016 10 May 19, 2016 9 May 20, 2016 8 May 21, 2016 9 I ...
Kim Stacks's user avatar
2 votes
1 answer
2k views

Same x-axis for multiple graphs in same plot window

I am trying to do exactly what the answer to this other question explains (I have several sets of data to be plotted in one graph with the same x-and y-axis); but with one difference: I don't have ...
Steeven's user avatar
  • 580
2 votes
1 answer
1k views

How to plot time series graph with categories?

I've data in Google Spreadsheets, with columns as follows: DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2 For example: 22.12.2010 APPLES 1 20 23.12.2010 APPLES 100 20 23.12.2010 ORANGES 32 12 I need ...
Alexander Gladysh's user avatar
2 votes
2 answers
2k views

Graphs with Google Spreadsheets - collapse data into one 'category'

I have a set of data which is similar to the following: Groceries 5.00 Groceries 14.75 Groceries 6.37 Dinner Out 43.50 Dinner Out 15.00 I'd like to be able to use this data to create ...
Noel M's user avatar
  • 297
2 votes
1 answer
189 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 ...
Adam's user avatar
  • 449
2 votes
1 answer
897 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 ...
Frank N's user avatar
  • 125
2 votes
1 answer
2k views

Create a Google Sheets graph with multiple lines in the same chart

I have data that looks like this: Name X Y Bob 0 15 Bob 3 20 Bill 0 24 Bill 5 30 And so on. Basically I want to have a line for Bob, a line for Bill, etc. With X as the X-...
KenArrari's user avatar
  • 121
2 votes
1 answer
3k views

Aggregate results by week and month for charts

Is there a way to convert daily values into weekly averages for charting? Sample source sheet --------------------------------------------------- | Data 1 | 1/1/2018 | 1/2/2018 | 1/3/2018 | etc......
Fernan's user avatar
  • 43
2 votes
2 answers
3k views

Create a pie chart using a formula

I'm using Google's monthly budget sheet to track my expenses. I need to have a pie chart but I don't want it to be floating around in the sheet and be in a specific cell(s). So I thought a formula ...
Henjin's user avatar
  • 121
2 votes
1 answer
4k views

Google Spreadsheets mixing up x- and y-axis on line chart, no option to change it

For some reason Google Spreadsheet insists on using the data I wish to have for my x-axis as my y-axis. Here I'll show what happens when I try to use my data to form a chart, and what happens when I ...
hiphopopotamus's user avatar
2 votes
3 answers
6k views

How can I chart based on day and month using dates in Google Sheets?

I have a Google spreadsheet that has values like: 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
Good Person's user avatar
2 votes
1 answer
430 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 ...
Yogi's user avatar
  • 21
2 votes
1 answer
1k 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 ...
Naunau1999's user avatar
2 votes
2 answers
920 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 ...
user avatar
2 votes
1 answer
527 views

Can results of ARRAYFORMULA be used as values in an annotated timeline?

I am trying to create an annotated timeline with the following data, which exists on another sheet: I am using an ARRAYFORMULA to retrieve the text. I want to display these values as an annotated ...
user avatar
2 votes
2 answers
1k views

How do I make a pie radar chart in Google Sheets?

I am trying to add a simple pie radar chart to a Google Sheets file for a college assignment. All I can find are simple pie charts. Anyone know how to upgrade them to pie radar charts?
user avatar
2 votes
1 answer
45 views

Different bar types based on column value

Instead of having one column for each new "type" below, is there any way to achieve the same result using the non highlighted cells in the image below? To elaborate, I would like different bar types ...
Johan's user avatar
  • 23
2 votes
2 answers
1k views

Suppress time part of the datetime values on a chart axis

I have a line chart based on the following data, capturing the Close Queue size every four hours: +---+-------------------+-------------+ | | A | B | +---+--------------...
user avatar
2 votes
2 answers
13k views

Change X and Y Axes

I am trying to graph the temperature of a substance versus the time the substance has been heated. My data is: A | B Time (Minutes) | Temperature (ºC) 0 | 22.8 .5 ...
Griffen's user avatar
  • 121
2 votes
1 answer
380 views

In a Google Sheets chart how do I prevent "Other" in the legend?

When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...
NoamNelke's user avatar
  • 413
2 votes
1 answer
78 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. ...
The Buggser's user avatar
2 votes
1 answer
18 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
user299539's user avatar
2 votes
0 answers
24 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?
Kajo's user avatar
  • 121
2 votes
1 answer
729 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 ...
Richard Millington's user avatar
2 votes
0 answers
2k 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:
Franck Dernoncourt's user avatar
2 votes
1 answer
150 views

Color or group the same kind of data in a Google Sheet graph

I have the following data: | Test Combination | C-Score | Memory | Reasoning | Verbal | |------------------|---------|--------|-----------|--------| | ABCD | 13.70 | 10.51 | 13.04 |...
Anon1234's user avatar
2 votes
0 answers
85 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 ...
hrrywllm's user avatar