Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
23
votes
5answers
90k views

How to plot time series graph in Google Sheets?

I know it is possible to plot graph or chart in Google Sheets but the problem with current plotting way is that you can only specify the Y, but not the X, and as such there is no way to plot a time ...
19
votes
2answers
76k views

How do I create a box plot chart in Google Spreadsheets?

I want to create a simple box plot from 1D data, which doesn't seem to be supported by the default Insert → Charts. There is a histogram gadget but I haven't seen any box plot gadgets. Do I ...
19
votes
2answers
81k 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 ...
16
votes
11answers
27k 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 (...
13
votes
2answers
19k views

How to label points in a scatter plot?

I've tried using the built-in scatter plot chart and the Google scatter plot gadget. I haven't been able to figure out how to get either one to allow me to label the points in the chart. I have data ...
11
votes
3answers
25k views

How to chart the count of items?

I have a spreadsheet that is filled by a form. It contains values like the following: Timestamp Person Category 2012-02-13 10.31.22 a x 2012-02-13 11.06.37 b y 2012-02-13 11.34....
9
votes
3answers
28k 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 ...
8
votes
1answer
4k 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,...
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 ...
7
votes
1answer
11k 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: ...
7
votes
1answer
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?
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 ...
6
votes
1answer
11k 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?
6
votes
1answer
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=...
6
votes
2answers
167 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:
6
votes
2answers
10k views

Chart of averages on Google Sheets

I have day by day data. I would like to display a line chart with this daily data as well as weekly average bar chart. How can I display daily as well as weekly trend chart by only having daily data ...
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.
5
votes
1answer
2k 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 ...
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: ...
5
votes
1answer
2k views

Statically positioned chart (ignore scroll)

I have a Google Sheets 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 static ...
5
votes
2answers
11k views

Plot Multiple Graph in Google Spreadsheet

I know how to plot a graph in google spreadsheet. But how to plot multiple graphs, with different X and Y values in Google Spreadsheet?
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 ...
4
votes
1answer
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"); ...
4
votes
1answer
476 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 ...
4
votes
1answer
239 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 ...
4
votes
1answer
424 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 ...
4
votes
2answers
5k 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 ...
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, ...
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 ...
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 ...
3
votes
2answers
7k views

Laying out dates in Google Sheets charts

I have a Google Sheets with measurements made at different dates. The data looks like this: 2010-09-01 80 2010-09-02 79 2010-09-10 81 I want the points that make up the data to be laid out so that ...
3
votes
2answers
4k 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? ...
3
votes
3answers
13k views

Why don't Google Sheets graphs lay out my points correcty?

When I try to make a simple graph of some points in a Google Sheets said points do not end up where I want them to in the graph. Using data like this I expect a straight line in my graph: col A col ...
3
votes
1answer
1k 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 ...
3
votes
1answer
3k 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 ...
3
votes
1answer
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 ...
3
votes
1answer
669 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:
3
votes
1answer
361 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 ...
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 ...
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 ...
2
votes
1answer
8k 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 ...
2
votes
1answer
83 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)?
2
votes
1answer
233 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
1k 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 ...
2
votes
2answers
1k views

Graphs with Google Spreadsheets - collapse data into one 'category'

I have a set of data which is similar to the following: Groceries 5.00 Groceries 14.75 Groceries 6.37 Dinner Out 43.50 Dinner Out 15.00 I'd like to be able to use this data to create ...
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
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 ...
2
votes
1answer
482 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
15k 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:...
2
votes
1answer
548 views

How to plot time series graph with categories?

I've data in Google Spreadsheets, with columns as follows: DD.MM.YYYY CATEGORY COUNTER_1 COUNTER_2 For example: 22.12.2010 APPLES 1 20 23.12.2010 APPLES 100 20 23.12.2010 ORANGES 32 12 I need ...