Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
0
votes
1answer
17 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
9 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
37 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
13 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
12 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
16 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
13 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
65 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
19 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, ...
1
vote
1answer
19 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
18 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
151 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
106 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
15 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
581 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
46 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
86 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
11 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
41 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
8 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
440 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
912 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
28 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
11 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 ...
0
votes
1answer
22 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 0
bing ...
0
votes
0answers
37 views
GAS & sheet with multiple variable height charts. How to set position
In a Google Sheet I am inserting multiple chart dynamically.
function formatCharts(cTargetSs,cSheetFrom,anchorRow) {
var sheet = cTargetSs.getSheetByName('Charts');
var sheetFrom = cTargetSs....
1
vote
0answers
296 views
How can I make x-axis sorted without sorting the underlying data?
I have a data set like this:
I want to plot the frequency of the 'num_of_item' as y-axis and the 'num_of_item' as x-axis.
As you can see on the x-axis, the num_of_item values are not sorted.
I ...
0
votes
1answer
67 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 | | |
+---------+-----...
1
vote
0answers
167 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 ...
0
votes
1answer
259 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.. ...
4
votes
1answer
3k 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, ...
1
vote
1answer
281 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 | ...
0
votes
2answers
416 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 ...
0
votes
0answers
32 views
Multiple columns as one in a 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 ...
0
votes
1answer
48 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 ...
-1
votes
1answer
240 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 ...
1
vote
0answers
2k 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 ...
0
votes
2answers
5k 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 ...
1
vote
1answer
64 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('...
2
votes
1answer
1k 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 ...
2
votes
1answer
411 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......
4
votes
1answer
357 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 ...
1
vote
1answer
31 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"...
0
votes
1answer
16 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 ...
5
votes
1answer
867 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: ...
-2
votes
1answer
193 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 ...
4
votes
0answers
4k 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 ...
0
votes
1answer
2k 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 ...
