Questions tagged [google-sheets-charts]
For questions specifically about charts/graphs created in Google Sheets
214
questions
2
votes
0
answers
625
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 (...
- 141
0
votes
1
answer
4k
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
2
answers
5k
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
...
- 790
3
votes
1
answer
3k
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 ...
- 33
1
vote
1
answer
407
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 "...
- 111
2
votes
1
answer
3k
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 ...
- 439
2
votes
1
answer
423
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 ...
- 123
2
votes
1
answer
45
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 ...
- 23
0
votes
1
answer
462
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 ...
- 121
0
votes
1
answer
794
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.
ndawg78
3
votes
1
answer
24k
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 ...
- 33
3
votes
1
answer
161
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 ...
- 131
5
votes
2
answers
3k
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 ...
- 227
1
vote
1
answer
732
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,...
9
votes
1
answer
22k
views
How do I modify the range of an existing Google Sheets chart?
I have inserted a chart into a Google sheet and need to modify the range of data it examines. I can manually define the range when I insert the chart using the chart editor as per the image below:
...
- 93
4
votes
1
answer
24k
views
Scatter chart with multiple data series
I want to create a scatter chart with Google Spreadsheets, which turns out to be very difficult. Based on a similar question here I came up with this approach:
What I want to achieve is sketched here:...
- 143
2
votes
2
answers
1k
views
Suppress time part of the datetime values on a chart axis
I have a line chart based on the following data, capturing the Close Queue size every four hours:
+---+-------------------+-------------+
| | A | B |
+---+--------------...
user79865
5
votes
1
answer
12k
views
Snap chart to grid or place a chart in a cell?
Is there a way to snap charts to the grid?
In my spreadsheet, my chart hangs a little below my table, but I would like the chart to expand/contract with the cells on the left.
If this is an easy ...
- 193
6
votes
2
answers
2k
views
Is there any way to enlarge the label area in Google Sheets?
I would like to increase the label area so that the label text doesn't get cropped. E.g. see red rectangle:
- 17.3k
1
vote
1
answer
56
views
Chart usage per interval from periodic readings
I have a series of monotonically increasing values associated with arbitrary dates. In this case, they're meter readings, but could be other values like mileage, fuel usage, etc.
29/05/2015 844.79
...
- 166
4
votes
1
answer
2k
views
How to access a gauge chart in Google Spreadsheets?
I have a gauge chart in my spreadsheet. I am looking for a line for accessing it.
function myFunction() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Gauge");
...
- 1,500
11
votes
1
answer
7k
views
How to move a standalone chart back to an existing sheet?
I regret moving my chart to a new spreadsheet in Google Sheets.
How do I move it back?
Using the revision history to undo the edit is not an option, since it has been a while since the original move,...
- 769
2
votes
1
answer
2k
views
Same x-axis for multiple graphs in same plot window
I am trying to do exactly what the answer to this other question explains (I have several sets of data to be plotted in one graph with the same x-and y-axis); but with one difference:
I don't have ...
- 560
5
votes
2
answers
11k
views
How to change the size of a published Google Spreadsheets chart that has its own sheet?
Google Spreadsheets offers the option to put a chart on its own sheet (instead of inserting it in the current sheet). This looks like a good idea for large charts.
However, I ran into an issue when ...
user79865
3
votes
1
answer
3k
views
Google Sheets Problem with Chart Axis
I have a Google Sheet with a some data that I need to chart. The horizontal axis should be a list of dates. When I plot the chart, though, it's inserting dates that aren't part of the data set. For ...
- 133
4
votes
1
answer
560
views
Can I use Google Chart Gallery in Google Spreadsheets?
Google Spreadsheets has column charts but I want to use "draw Annotations" like this (Annotations). Column chart doesn't show bar value as "draw Annotations" on top.
My chart included these:
First ...
- 81
-1
votes
1
answer
859
views
Google Sheets trendline broken; file unavailable
In Google Sheets, I've created a line graph.
I want to add a trend line. I do so by clicking the blue line and selecting Linear from the trendline dropdown.
No trendline appears. Then when I right ...
- 99
5
votes
1
answer
6k
views
Insert a datatable directly under my chart in Google Spreadsheets
How do I create a data table directly under my chart on Google spreadsheets? I want to achieve something similar to the figure below. In MS Excel it is called datatable and it is inserted by a click ...
- 335
4
votes
1
answer
297
views
Explaining proper meaning of columns to Google Sheets chart editor
I'm trying to make a simple chart displaying the number of events that occurred each month in X years. This means I want a chart that shows:
X colored lines, one for every year
Month names marked on ...
- 858
2
votes
3
answers
2k
views
How can I make Google Sheets tell me how many of each date are in a column?
I have a column in my spreadsheet that contains only Date values, like:
2014-05-17
2014-06-19
2014-07-16
2014-07-16
2014-07-21
2014-07-21
2014-07-21
2014-07-21
2014-07-21
2014-06-17
2014-06-24
2014-...
- 121
7
votes
1
answer
9k
views
How to choose custom colors for Google Spreadsheet charts?
When selecting the color for a line in a chart, I see 80 choices of colors. Is there a way to add new colors or set a color using RGB, HSV or HTML colors?
- 487
34
votes
3
answers
148k
views
Create a Google Sheets chart with multiple data ranges with separate key columns
I have this data:
X1 Y1 X2 Y2
1 20 1 25
2 20 3 42
3 20 6 50
5 25 8 50
10 30 10 50
I want to create a ...
- 733
3
votes
2
answers
6k
views
Create chart from single column
I used a survey to collect data about people's opinion. The question is answered using a check-box (Yes/No). I would like to visualize the results using charts.
How can I do that using one column?
...
- 133
1
vote
1
answer
446
views
Update Google Drive Chart based on which row selected
I have a table with some pretty basic data (it's a time series going across the columns, and different budget items going down). I want to create a chart that plots a particular row's data against ...
- 11
0
votes
2
answers
2k
views
Create chart with total for each score
I have a column within a Google Spreadsheet with values like this:
96
97
96
100
97
97
100
97
95
95
96
I'd like to add a bar chart where each bar represents one of the values and the height of the ...
spiffy
6
votes
1
answer
3k
views
Stacked area graph of time/duration values
How can I create a stacked area graph of time/duration values?
I have a set of times for each date which correspond to each leg of a journey.
https://docs.google.com/spreadsheet/ccc?key=...
- 166
3
votes
1
answer
685
views
Creating a chart with independently indexed series
I have a data series that looks like this (bigger data set but that's accurate):
0 317.59
1.4 317.59
1.5 408.77
2.15 408.77
2.25 440.46
2.98 440.46
3.08 ...
- 453
0
votes
2
answers
3k
views
Generating charts from Google Forms data via Google Sheets
I have two columns that are generated from a Google Forms:
I would like to create two pie charts, one for City A and one for City B, showing the percentages of male and females from those cities. I ...
- 188
2
votes
2
answers
3k
views
Is there a way to count how many entries in a given column have a particular value?
I have a spreadsheet which keeps track of duels between two players in a game. Each row has the number of the match and the winner, given by their initial, X or Y. I want to know if it's possible to ...
- 1,157
2
votes
2
answers
13k
views
Change X and Y Axes
I am trying to graph the temperature of a substance versus the time the substance has been heated. My data is:
A | B
Time (Minutes) | Temperature (ºC)
0 | 22.8
.5 ...
- 121
4
votes
1
answer
7k
views
Chart with points in Google Spreadsheets
I have a Google Spreadsheet with a line chart. Despite the name "line chart", the data does not appear regularly spaced on the x-axis but according to a date column. (This shows up correctly, no need ...
- 143
2
votes
1
answer
3k
views
Google Spreadsheets mixing up x- and y-axis on line chart, no option to change it
For some reason Google Spreadsheet insists on using the data I wish to have for my x-axis as my y-axis. Here I'll show what happens when I try to use my data to form a chart, and what happens when I ...
18
votes
3
answers
17k
views
Statically positioned chart (ignore scroll)
I have a Google Sheets document with four columns of data. I have a chart on the right side. When you scroll down to see all the data, the chart scrolls up off the screen.
Is there a way to make it ...
- 486
20
votes
3
answers
72k
views
2-axis line chart in Google Sheets
I've set up a Google Sheets to compare one set of statistics against another. The statistics are for traffic vs. an action. The actions only happen once a day and not every day whereas the traffic has ...
- 6,823
2
votes
1
answer
363
views
In a Google Sheets chart how do I prevent "Other" in the legend?
When there are over 8 series in a chart (this is true at least for a pie chart) - Sheets combines all other series above the 8th into "Other" this is really counter productive when there are only 9 ...
- 403
2
votes
1
answer
12k
views
Add headers to Google Spreadsheet chart [closed]
I have a chart in a spreadsheet. If I click on it and select 'advanced edit' > Start,
it offers to 'Use row 12 as headers'. How can I use a different row for the header names?
My data has rows for the ...
- 131
3
votes
1
answer
4k
views
How to share with others a poll's result as a chart?
I've created a form on Google Drive. The form is public, anyone can see it and respond to it. I would like also to provide a link to the data gathered by the form, however I would like to provide the ...
- 141
3
votes
1
answer
1k
views
Why is "access denied" to multisheet charts in published Google Sheets?
I can successfully include a chart based on a single sheet, but as soon as I combine ranges from multiple sheets, I get an access denied error.
Example spreadsheet
Published spreadsheet
What am I ...
- 611
6
votes
1
answer
14k
views
Add average line to scatter graph
I have the following scatter plot in Google Sheets and I would like to add a line that averages all my points.
Can I do that and if yes, how?
- 255
18
votes
12
answers
41k
views
Downloading charts from Google Sheets in high resolution
I have a Google Sheets with data from which I've created a few charts using the built-in charting tool. Now, I'd like to download these charts in a format I can use in a PDF document I create locally (...
- 433