Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
1
vote
1answer
34 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
16 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
14 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
10 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
29 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
12 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
13 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
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
23 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
24 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 ...
1
vote
1answer
18 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
11 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
15 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
23 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
13 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
17 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
0answers
363 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
10 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!
0
votes
0answers
13 views

How to make one of lines continuous in Google Sheets?

I drew fitting plot in Google Sheet, but both series were depicted by separate dots How to make red series continuous? If I choose edit, I get only settings for dots
1
vote
1answer
80 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....
0
votes
0answers
17 views

How to create chart until today's date, automatically, every day?

On a row from left to write there are dates (daily). Manually written, but automatically populated. On another row, there are formulated numbers (formulated for each date). The chart gets those ...
0
votes
0answers
19 views

Creating a horizontal decision tree in Google Sheets - Can the one flip the default one?

I want to create a horizontal decision tree in Google Sheets - the default one is vertical - moving from top to down, I want mine to be like a decision tree from left to right branching out. How can ...
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 ...
0
votes
0answers
11 views

Finding a cell value based on row and column

I have a little problem that might not be solved just with formulas. And I am not so advanced in JavaScript yet. I have a list of products, our salesmen, customers and time when and how much the are ...
1
vote
1answer
35 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 ...
0
votes
0answers
67 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
251 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 ...
0
votes
0answers
14 views

Creating a Scatter PLot with Equal Axis Scale

When creating a Scatter Plot in Google Sheet, the X and Y axes get scaled independently. Is there a way to set them to always use the same scale/units? Basically, such that given a point (10,10)...
-1
votes
0answers
39 views

Google Sheets: Stacked bar chart showing event totals by month

I have a Google Sheets spreadsheet that tracks four types of events on a daily basis; we'll call them A, B, C, and D. More than one event can happen on a day; if this happens there are two (or more) ...
0
votes
1answer
291 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 ...
0
votes
1answer
155 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 ...
1
vote
0answers
106 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
1answer
24 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 |...
1
vote
0answers
18 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 ...
4
votes
1answer
3k views

How to use “aggregate” chart feature on Google Sheets

Line graphs and most other types in Google Sheets have a checkbox for "aggregate" in the setup tab. I've tried looking through the instructions but I can't find any documentation on how to use this ...
2
votes
1answer
112 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)?
-1
votes
0answers
142 views

Plot multiple data ranges in Google Sheets

I'm doing a physics lab in class and we conducted multiple runs of a car rolling down a ramp. For each run, there are two columns of data for time and position. I want to graph all the data on a ...
-1
votes
0answers
57 views

Plot coordinate data in a scatterplot in Google Sheets

I'm an inexperienced student using google sheets for my lab report. In the following data, each row represents data for each of 4 people: xi (columns B-E) represents a position in meters, and ti (...
1
vote
1answer
35 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
1answer
237 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-...
0
votes
1answer
488 views

How to customise ordering of segments in stacked waterfall chart using Google Sheets

I've drafted a stacked waterfall chart in Google Sheets (shown below). By default, the ordering of stack segments are as follows: In Column A: Apples, Bananas, Carrots, Durian from top to bottom In ...
0
votes
0answers
357 views

Unable to position custom data labels in center in Google Sheets waterfall chart

Context I've drafted a stacked waterfall chart in Google Sheets, with custom data labels (guided by Ben Collin's tutorial on custom data labels). My goal is to have the custom data label positioned ...
1
vote
0answers
61 views

In Google sheets is it possible to have a combined chart with stacked columns?

I currently have a simple combined chart with a revenue line and columns. For what I am trying to communicate with this graph, I would really like to have stacked columns in addition to my revenue ...
2
votes
1answer
299 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, ...
1
vote
1answer
19 views

How to Change Agregated Data to Continuous

I would like to change the following two graphs in this link here Problem 1 Under the chemistry and physics tab I have a graph like this: Which is an agregate data set, but as you can tell the x-...
3
votes
2answers
13k views

How to change the values of a pie chart to absolute values instead of percentages in Google Sheets

I want to be able to change the percentages under each of the fruit names to absolute numbers (the respective quantities). I tried changing the 'slice label' but that only added the numbers over the ...
0
votes
1answer
609 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 ...
0
votes
1answer
222 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
1answer
18 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...
1
vote
1answer
27 views

Google Sheets time sorting chart

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 ...