Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
149
questions
0
votes
0answers
8 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
38 views
Google sheets: How do you forecast numbers each month in a range that's non-linear?
I've imported a sample of monthly youtube channel viewership figures from google API.
I'd like to use the data to forecast what the expected number of views was on each channel for the latest month, ...
0
votes
1answer
16 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
0answers
22 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
20 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
14 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 ...
1
vote
0answers
20 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
77 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)?
0
votes
0answers
20 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 ...
0
votes
0answers
16 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
32 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
26 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
0answers
43 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
49 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
32 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
294 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
17 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-...
1
vote
1answer
1k 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
0answers
6 views
How to create a chart a non zero starting point
I am creating a chart from data, the numerical range of the data is 50 to 150.
The problem is the chart starts at 0.
I would like to force the chart to start at 50.
I have looked at the grid line ...
0
votes
1answer
75 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
61 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
12 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
14 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 ...
0
votes
1answer
27 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 ...
0
votes
1answer
122 views
How to preserve colors of each series from changing when inserting new data in Chart Editor?
This issue occurs in every chart type. As an example, I have a pie chart created from a long table of data where each column is assigned a specific text color, so each slice of the pie corresponds to ...
1
vote
2answers
577 views
Does Google Sheets allow moving a chart to its own sheet?
I know that Google Sheets used to allow moving a chart to its own worksheet so that nothing else is in that sheet. All the instructions I've found for how to do so are no longer relevant to the most ...
0
votes
1answer
13 views
How do I turn a SQL database downloaded table into a Google Sheets multi-line chart?
I want to turn this table (comes from an SQL database)
...into a line chart in Google Sheets that looks like this
0
votes
0answers
18 views
Google sheets sub-chart in chart… possible?
I have 3 different data ranges that I need to plot on a google sheets chart. On the main chart I have different value ranges, thus I'll use a left y-axis and a right y-axis, but the 3rd data range is ...
0
votes
1answer
18 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 ...
0
votes
0answers
18 views
Build a value-over-time line chart from monthly values?
I have a spreadsheet that looks like this:
+---------------------------------------+
| |01|02|03|04|05|06|07|08|09|10|11|12|
+---------------------------------------+
|'16| ?| ?| ?| 1| 2| ?| ?| ?| ...
0
votes
1answer
14 views
Bar Chart Merge 2 columns in a single bar
I have the following table, I want to generate a bar chart where for each year I can see a single bar, including both Cash and Credit.
Today I only see this:
Link here
0
votes
0answers
189 views
Multiple columns on x-axis on Google Sheets chart
I have a google sheet tracking $ for different categories (savings, regular expenses, daily expenses). I like to keep track of individual dates and transactions.
As you can see, only Daily is showing ...
0
votes
1answer
71 views
Google sheet chart, wrong time format in chart
I have created a Google Sheet that collects a bunch of values in columns. One of these is a time value formatted hh:mm:ss AM/PM, obtained with the following formula:
=TIMEVALUE(SUBSTITUTE("April 28, ...
0
votes
1answer
45 views
Google Sheets table of data wont create graph accurately?
So I am trying to convert some data into a scatter plot using Google Sheets. I have 2 problems:
When I try and order the x and y so that the graph has x data on x and y on y it inverts it. May this ...
1
vote
1answer
21 views
Map Axis Numeric Values to Strings
I have time series data reviewing the quality of an item. The ratings are on a 1-5 scale ranging from "Very Bad" to "Very Good". How can I define this mapping so that instead of seeing marks for 1, ...
0
votes
1answer
43 views
Is there any way to let the data range of a chart in Google Sheets dynamically adjust?
Say I have a table like this:
| Date | Number |
| 0128 | 28800 |
| 0129 | 32500 |
| 0130 | 63410 |
| 0131 | 56400 |
| 0201 | 68700 |
| 0202 | 84060 |
And I can put a graph to show ...
0
votes
1answer
468 views
Google Sheets show running total and average on a chart
I have a dataset of expenses as rows and a monthly budget $ in a cell.
I want to plot two bar horizontal bar charts where the X-axis is the days of the month (all of them, not just the one we're up ...
1
vote
1answer
236 views
Creating running total chart
I want to create a chart in Google Sheets with cumulative Profit (H) column but without creating the second column (I). Are there any solutions?
0
votes
1answer
16 views
Comparison Column Chart
I'm trying to make a chart in Google Sheets to compare how much two people have paid towards something. What I'm looking for is the chart to have several cost categories (groceries, dining out, pets, ...
1
vote
1answer
2k views
Pie chart with sub-slices per category in Google Sheets?
I have a sheet that contains a list of books, with metadata about those books. Two columns that exist are the library within which the book is stored, and the condition of the book. I'd like to create ...
1
vote
1answer
87 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 ...
0
votes
1answer
30 views
Blank Redundant Month
I have a large list of days and quantities that I wanted to chart so we could see how many of something we sold on a specific day.
Give this goes back 600 days, there is a lot of data so I have been ...
0
votes
1answer
127 views
Dynamically creating chart in Google Sheets
I'm looking for a way of automatically generating a graph based on a constantly expanding dataset.
The number of columns is constantly expanding (a program create a new column with new datasets for ...
0
votes
0answers
15 views
How to prevent series from changing color when series are removed from the chart/graph?
I have a graph, similar to the one in this gif:
When I uncheck different series, removing them from the data that is then read by the graph, the colors shift. I believe the issue is that the color ...
1
vote
1answer
70 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 ...
0
votes
0answers
10 views
How to create a line chart from a key-value dataset?
I have created a script that tracks twitter followers over time, for many accounts, the data is saved to a table that looks something like this:
+------------+--------+-------+
| DATE | USER |...
2
votes
2answers
878 views
How to plot dates on a timeline in Google Sheets
I have a column of dates, eg.
2017-01-20
2017-01-25
2017-01-27
2017-01-30
2017-02-03
...
2018-12-20
I would like to create a plot where the x-axis is a contiguous range of dates from start to end (...
0
votes
1answer
2k views
How to reorder labels on Google sheets chart?
See the below chart that was created from Google Sheets:
I want to reorder the positioning of the bars in the x-axis - for example, move the "Over $121" bar to the far right and move the "Between $21 ...
0
votes
0answers
40 views
How to create a chart with list of values as aggregated separate values?
I'm trying to do something similar to how Google Forms populated my data (which was with checkboxes, where multiple options could be checked):
This data in Google Sheets is represented as a column, ...
1
vote
0answers
12 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 ...
