Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
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: ...
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
2answers
243 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 | +---+--------------...
2
votes
1answer
3k 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 ...
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:
1
vote
1answer
50 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 ...
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"); ...
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,...
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 ...
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 ...
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 ...
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 ...
-1
votes
1answer
778 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 ...
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 ...
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 ...
1
vote
3answers
723 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-...
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?
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 ...
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? ...
1
vote
1answer
391 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 ...
0
votes
2answers
1k 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 ...
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=...
3
votes
1answer
362 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 ...
0
votes
2answers
2k 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 ...
1
vote
2answers
1k 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 ...
2
votes
2answers
11k 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 ...
2
votes
1answer
2k 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 ...
1
vote
1answer
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 ...
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 ...
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 ...
2
votes
1answer
193 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 ...
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 ...
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 ...
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?
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 (...
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 ...
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....
2
votes
1answer
3k views

Can I precisely position charts in Google Sheets?

I am using Google Sheets to create a "Monthly Report" spreadsheet for a product, and am attempting to make an attractive, compelling experience for the consumers of the report. In this spreadsheet, I ...
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 ...
2
votes
2answers
2k views

How to calculate and chart cumulative flex time?

Being a (productive) geek, I want to keep track of the trend of my flextime. I keep a personal document of my hours worked in Google Sheets, having one column for hours worked every day. By ...
-2
votes
2answers
867 views

Not getting sub date granularity in Google Sheets trend lines

My data is in variable increments, anywhere from six to eight hours apart like so: 1-1-2011 00:00:00 100 1-2-2011 00:00:00 103 1-3-2011 00:00:00 107 1-4-2011 00:00:00 109 1-4-...
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 ...
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 ...
2
votes
2answers
2k views

How can I chart based on day and month using dates in Google Sheets?

I have a Google spreadsheet that has values like: 1/1/10 0 1/2/10 43 1/3/10 17 etc. I want to be able to visualize the data on a day-by-day basis and on a month by month basis. I managed to create ...
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
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 ...
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 ...
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?
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 ...