Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
0
votes
1
answer
1k
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 ...
- 103
1
vote
1
answer
101
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, ...
- 113
0
votes
1
answer
2k
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 ...
- 25
1
vote
1
answer
7k
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 ...
- 11
1
vote
1
answer
659
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
1
answer
43
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, ...
3
votes
1
answer
17k
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 ...
- 33
2
votes
2
answers
843
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 ...
thomasjohansen
0
votes
1
answer
36
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 ...
- 63
0
votes
1
answer
269
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 ...
2
votes
1
answer
519
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 ...
user205834
3
votes
2
answers
9k
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 (...
- 151
8
votes
2
answers
37k
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 ...
- 181
1
vote
0
answers
29
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 ...
- 111
0
votes
1
answer
1k
views
How to group certain data in a chart in Google Sheets
I'm creating a chart of a number of items (website traffic sources) and want to find a way to merge any rows that contain 'Facebook' in the chart.
Here's the raw data:
(direct) 67
192.com ...
- 109
1
vote
1
answer
2k
views
How to create a 3 column chart in Google Sheets with one numerical column and two text columns with customization?
Consider this data:
Food
Quantity
Type
Apple
3
Fruit
Spinach
1
Vegetable
Mango
2
Fruit
Almond
1
Nut
I want to convert this to a chart with X and Y axis being the food name and the quantity. But ...
- 111
2
votes
0
answers
520
views
How to align one axis in a two axis chart
I want to align my right vertical scale with my left vertical scale so both have the 0 at the same height.
I have this:
And I want this (I've done it manually but it's not perfect, look how both 0s ...
- 21
1
vote
1
answer
1k
views
How to make Google Sheets draw trends in a spreadsheet
I have a graph on Google Sheets (based on two columns) that plots many points (think of it like the stock market):
I would like the graph to not show the micro data and instead show trends.. ...
- 1,179
10
votes
4
answers
51k
views
How to reverse the y-axis in a Google Sheets graph?
I have data that represents the depth of an open mine in a transversal view.
Currently, it looks like this:
But since it represents the depth of a mine, I'd rather have it "flipped". So the y-axis, ...
- 200
1
vote
1
answer
484
views
Display month and year on chart
I have a line chart created after data that's stored like this:
A B C D
1 | 2017 | | 2018 | |
2 | NOV | | FEB | |
3 | 0 | 0 | ...
- 111
0
votes
3
answers
3k
views
Multiple columns as one in an Google Sheets chart
I have a Google Sheet tracking data over days, logging data at different times during the day, example:
Is there any way that I can have this data represented in a chart as one continuous line ...
- 111
0
votes
1
answer
113
views
Is Google Sheets capable of making a gantt-like chart like this? If so, how?
I have two columns in a spreadsheet: A1:A100 has start times, and B1:B100 has duration. I am trying to create a chart that looks something like this, where each row gets a vertical line placed at the ...
5
votes
3
answers
4k
views
Chart labels disappear (stays outside the graph area) Google sheets
Really count on your help here, as it seems like I tried everything already.
Take a look at the graph: the last value label disappears (the location is right on the inner border of the graph, so the ...
1
vote
1
answer
115
views
Aggregate data with Sheets pivot table or graph
Please have a look at this google sheet here.
It has a pivot table with 3 columns:
A period (for example: 2016/01), a category and a number. I would like to do a chart that looks like this:
For ...
- 131
1
vote
1
answer
2k
views
How to create an histogram with inner divisions in Google Sheets?
I have a column of grades on a Google Sheets document and I want to generate something like that:
I only managed to create a simple histogram with custom bucket size, but I want it to be more ...
- 3,884
4
votes
1
answer
15k
views
Showing percentages in google sheet bar chart
It looks like bar charts in Google Sheets won't support percentages.
Is this correct?
If so, how would a change the populating query that currently returns "count of"?
A single cell used as the ...
- 579
1
vote
3
answers
41k
views
How do I combine two different types of charts to compare two types of data?
I am trying to plot two different types of data: segmented volumes and rating. In the linked example data sets & charts you will find two different charts that I am trying to combine.
The first ...
- 533
1
vote
1
answer
160
views
How to add a date to a cell next to an cell with an imported value
In column A I have a value added each day from the tab/cell TOTAL/A1 by this script:
function dailyLog() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sourceSheet = ss.getSheetByName('...
- 11
4
votes
2
answers
6k
views
Bar chart of time ranges in Google Sheets
Overview
I have a spreadsheet with 3 columns [Name, Start time, End time] which is for scheduling purposes. I want to create a bar chart showing all of the people's availability as a series of ranges ...
- 397
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......
- 43
4
votes
1
answer
544
views
A chart with multiple series encoded by comma-separated names
I have the following table
I need a graph with dates on X axis (with the option to group by weeks/months/years), values on Y axis and lines for each name (A,B and C) representing the sum of values on ...
- 41
1
vote
1
answer
61
views
Format Google Analytics Date
I'm using the following formula to retrieve week day and day from a Google Analytics report in Google Spreadsheet:
=CONCATENATE(CHOOSE(WEEKDAY('90diaspessoas'!A16),"Domingo","Segunda","Terça","Quarta"...
- 123
0
votes
1
answer
27
views
Google spreadsheet data not showing properly in graphic
I'm using =CONCATENATE('90diaspessoas'!B16," ", TO_TEXT('90diaspessoas'!A16)) to join two cells data into one, then display the data on a graphic.
The following picture shows the result that I'm ...
- 123
5
votes
1
answer
3k
views
How can I stop Google Sheets charts from rounding down durations?
I've got a Google Sheets chart that displays the average pace of a day's rowing machine workouts (e.g. average the time to row 500m).
It looks like this:
The Query I'm using to get the data is this: ...
- 151
-2
votes
1
answer
306
views
Investing.com data uploaded but i am not able to use the data for email alerts.kindly help me [closed]
I have configured to fetch the data on every 1 min from investing wesite.
The table data is fetching from website. while trying to update date when 15 minutes status D column change to either strong ...
6
votes
3
answers
13k
views
Set title of currently selected chart from named cell
There's a sample over here that will show how to set the first's chart title to the active cell:
function onOpen(){
SpreadsheetApp.getUi().createMenu('Charts').addItem('Update title of the first ...
- 579
0
votes
1
answer
5k
views
Chart with events by month from a series of dates
I have a spreadsheet on google drive with a series of dates in a column, each date representing a particular event.
1998-01-07
1998-01-10
1998-01-22
1998-01-23
If I have two or more events on the ...
- 103
0
votes
1
answer
4k
views
Bar chart with dates on X and two values on each each date
I want to create a bar chart in Google Sheets which looks (pretty much) like this :
From data that looks like this :
As you can see in the first picture the date labels along the X axis skip a date ...
- 143
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:
- 331
5
votes
1
answer
1k
views
Dynamic range in chart
I have a chart of my table, but I keep adding rows to it.
Is there a way to define the chart's Series/X-Axis/Range as part of a formula?
I want the graph to grow as my table grows - dynamically.
- 163
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?
Dave Lee
0
votes
1
answer
263
views
Stacked Bar Chart summing repeated daily likes
I have table with two columns, Date and Likes. For each row in Date, I have a value in Likes, this pair represents the the likes we received every day.
I want to create stacked bar chart, grouped by ...
dombi soma
0
votes
1
answer
84
views
Chart only rows with "x"
I have a Google Sheets with measurements I take daily (the rows), multiple times a day. I have a "before breakfast" column, values are "Yes" or "No". How do I make a chart which shows only the "before ...
3
votes
1
answer
7k
views
How to merge x-axis data from two ranges?
Consider the data below:
1-Jan-2010 3 2-Feb-2009 9
5-Apr-2010 4 18-Apr-2010 5
10-Sep-2012 9 1-Oct-2011 8
The first two columns are for individual A, the last two for individual B.
Is it ...
- 423
2
votes
2
answers
2k
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 ...
- 121
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 ...
9
votes
3
answers
38k
views
How can I skip columns in a Google Spreadsheets Chart?
I have a table of data in a Google spreadsheet that we want to use to create multiple charts. The issue we are facing is that some of these charts omit certain columns. We don't want to remake the ...
- 213
1
vote
1
answer
1k
views
How to plot dates / times in 1 chart in Google Sheets?
I have two columns with date/time data. One column represents the day with a date and the other represents the time I had my first coffee for the day.
I would like to create a chart out of this so I ...
- 113
7
votes
2
answers
19k
views
Variable Error Bars in Google Sheets Graphs
I have a data series that consists of multiple data series. I want to graph the average and the variance. I already calculated a single data series for the average and for the variance.
Now I want to ...
- 201
4
votes
1
answer
6k
views
How to increase precision of labels in Google Spreadsheets chart?
I created a chart in my Google Spreadsheets. For the sake of example let's say that horizontal labels are months of the year, for example 01.2016, 02.2016, 03.2016 etc. and vertical labels are amount ...
- 143