Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
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 ...
0
votes
1answer
160 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
1answer
348 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
241 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 ...
1
vote
1answer
432 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
2answers
6k 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
329 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
963 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
1answer
61 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
428 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 ...
2
votes
0answers
3k 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
9k 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
84 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
2k 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
905 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
427 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
40 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
18 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
1k 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
229 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
1answer
5k 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 ...
0
votes
1answer
2k 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 ...
3
votes
1answer
684 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:
5
votes
1answer
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.
2
votes
1answer
570 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?
0
votes
1answer
240 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 ...
0
votes
1answer
55 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
1answer
4k 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 ...
1
vote
2answers
402 views

Create a pie chart with 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 ...
2
votes
1answer
1k 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 ...
1
vote
0answers
155 views

Charts show '1' for zero values

I have a big file with charts. For calculations I formatted all values with the following string: #;-#; to avoid the showing of zeros in charts. Now data labels which should be empty are shown as 1. ...
6
votes
3answers
15k 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 ...
1
vote
1answer
439 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 ...
7
votes
2answers
13k 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 ...
2
votes
1answer
2k 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 ...
1
vote
0answers
342 views

Chart in Google Sheets is duplicating data labels

I'm using Google Sheets and a triggered Apps Script function to create a waterfall chart. Basically this involves breaking apart each value into a base (either visible or invisible), a falling value (...
0
votes
1answer
2k views

Combination chart Google Spreadsheets

I'm making a combination chart showing the growth of a value week by week as columns, while for the line I want to illustrate the percentage change week by week. The problem is that the column values ...
0
votes
2answers
3k views

Set order of rows or columns to be in numerical order in a Google Sheets Chart

I have a Google spreadsheet that lists ratings (1-10) that various participants gave for various topics: Person Topic A Topic B ------------------------ Claire 4 5 Diane 6 8 ...
3
votes
1answer
2k 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 ...
1
vote
1answer
200 views

Timestamps in scatterplot

I have a Google spreadsheet with two sheets. The first one is for data input from my Android phone using Tasker. Input sheet looks like this: clock duration 16,25 29 6,45 23 16,3 35 where "...
2
votes
1answer
485 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 ...
2
votes
1answer
234 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 ...
2
votes
1answer
44 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 ...
0
votes
1answer
196 views

Create Google chart from dynamic number of sheets

Is there a way to create a chart based on an ever-growing folder of sheets? For instance, if I want to graph the running average of some value always found in cell A1 across all sheets within a ...
0
votes
1answer
480 views

A sparkline from data in every sixth cell in a row

I am creating a spreadsheet in Google Sheets where every sixth column is a "total" column. I need to create a sparkline that will grab the value of every sixth cell in that row.
2
votes
1answer
8k 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 ...
3
votes
1answer
119 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 ...
4
votes
2answers
2k views

How can I embed a chart from a Google Spreadsheets in a Google Doc?

I would like to embed the chart from a Google Docs spreadsheet into a Google Docs Document, so changes to the original will be reflected in the embedded version. I found a way to embed a static image ...
1
vote
1answer
311 views

How to get most frequent terms from a set of lists?

I have a list on Google Spreadsheets. Each line is a mission, and one of the columns indicates who I've worked together on the mission (which is between 1 and 3 people). The format is "Aquaman, Batman,...