Skip to main content

Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
3 votes
1 answer
176 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 ...
1 vote
1 answer
3k 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 Spinach 1 Vegetable Mango 2 Fruit Almond 1 Nut I want to convert this to a chart with X and Y axis being the food name and the quantity. But ...
0 votes
1 answer
478 views

How to add a secondary vertical axis to a timeline chart in Google Sheets?

I have a timeseries chat plotting two different series, see here: https://docs.google.com/spreadsheets/d/1TGoHPodslxw01PVf8Yp4SI15saedY8iID3FegJg6lmg/ I would like to have 2 different Y-axes, one for ...
0 votes
1 answer
2k views

Stacking time series in Google Sheet Combo chart

I can approximate a stacked time-series plot using the Combo chart option in Google Sheets: But it's not quite a "real" time series plot because the temporal gaps are not represented. Compare to this ...
0 votes
1 answer
2k views

Getting error while using inlineImages

I am always getting error while using inlineImages. Error Exception: Invalid argument: inlineImages" Below is my code: var blob = Charts.newTableChart() .setDataTable(table.build()) ....
0 votes
1 answer
368 views

How to keep my chart unchanged when deleting rows from data source?

Could anyone kindly advise how to keep my sample chart unchanged after deleting the unnecessary Row 2? I have a Google Sheet that contains over 50 charts whose data source is within only one big data ...
1 vote
1 answer
2k views

Chart on Frozen Cells in Google Sheet

Is it possible to place a chart outside the scrollable part of a google sheet when some rows and columns are frozen. I tried removing the frozen panels first, creating the chart and freezing columns ...
1 vote
2 answers
2k views

Change colors on graph

I have a graph on google sheets, and want to change the background color for certain values on x axis. For example, from a value A to a value B (on x axis) I want a background color 1, then from ...
1 vote
1 answer
127 views

Aggregate data with Sheets pivot table or graph

Please have a look at this google sheet here. It has a pivot table with 3 columns: A period (for example: 2016/01), a category and a number. I would like to do a chart that looks like this: For ...
0 votes
1 answer
65 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
2 answers
3k views

What is the chart type that will compare value-pairs?

I'm trying to build a chart in Google Sheets to compare my portfolio contributions by year with the allowed maximums. I would like to be able to filter by year and for each account display the total ...
0 votes
1 answer
352 views

Google Spreadsheets Charts: Drawing continuous chart based on multiple data ranges

I have a big set of data that I split it into 2 ranges (here I am just showing small data for clarification). I want to draw one chart based on those 2 ranges, to get a result as the "Desired ...
2 votes
2 answers
3k views

Google Sheet: is it possible to make a chart's vertical axis' Min and Max values automatically adjust according to the values in the dataset?

I want to have my chart, which displays a range of data that updates periodically, to represent the changes across sampled values in a more zoomed-in form by having the minimum value of the vertical ...
0 votes
1 answer
1k 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 ...
18 votes
3 answers
71k 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....
0 votes
1 answer
291 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 ...
12 votes
3 answers
41k views

How to rename a series in Google Sheets chart?

By default, a Google Sheets chart will use the first row as the the name of the Series. But if you are selecting a range in the middle of the table (for example, rows 38-100), then you can't use the ...
3 votes
1 answer
6k 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 ...
1 vote
1 answer
54 views

Visualize Data that updates dynamically

TLDR: How can I create a bar chart that updates the x-axis daily? The end goal is to have a chart that shows a side by side comparison of goal completions performance for each source of traffic. Here ...
2 votes
1 answer
19 views

Google sheet trend chart help

Is there a way to display this years data like it is in this chart but have a cut off so the line doesn't drop to 0? Please see attached image Many thanks
0 votes
1 answer
86 views

How do I chart timeseries data organized by one of the columns?

Here's what seems to be a simple common thing in excel/sheets that I can't seem to be able to google in the right way. three columns: timestamp, email, things_done. I want a chart with time as the X ...
12 votes
4 answers
59k 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, ...
0 votes
1 answer
47 views

Create a Chart for Membership Data

Was wondering how to best set up data to create charts for memberships. I want to create a chart that compares # of New Members vs. # of Cancelled members. In the data, I have one columns that ...
0 votes
3 answers
3k 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 ...
1 vote
1 answer
2k views

How can I show specific points in a smooth line curve on Google Sheets

I was able to create this graph However, I want to know how I can have dots that represent the specific points, while still having this be a smooth curve.
1 vote
1 answer
214 views

Cannot create pie chart in which all values are identical

I am unable to create a pie chart in which all responses are identical, or, in other words, in which 100% of the responses are represented by a single value. When I try to create such a chart, for ...
0 votes
1 answer
190 views

How to assign a name to a membership number vice versa?

I would like to learn what formula I can use to make my timesheet more efficient. How to assign a membership number to a name vice versa? I need to add lesson hours to each membership daily and ...
3 votes
1 answer
326 views

Struggling to Generate Chart From Existing Data

This question is specific to Google Sheets—hopefully I’m in the right place. https://docs.google.com/spreadsheets/d/161rtpjNK5363-U6y6MZYzqOIx7CQBCHDWInBXFtZYIg/edit?usp=sharing As you’ll see above, ...
2 votes
1 answer
152 views

chart select data: there are more items than can fit in the menu

I have time series data with at least 250 data points. I graph the data with a Sheets Line Chart. I'd like to add some data points with labels to the graph via the Add Select Data Point option. ...
1 vote
1 answer
160 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('...
0 votes
1 answer
1k views

Multiple Groups Graph on Google Sheets. Please Help

I got the following table on google sheets. Text version +----+---+---+----+ | | A | B | C | +----+---+---+----+ | 1 | 1 | 2 | 1 | +----+---+---+----+ | 2 | 2 | 1 | 1 | +----+---+---+----+ | ...
0 votes
1 answer
783 views

Google Sheets - Filtering Chart Data with Checkboxes

In Google Sheets, I'm making a 'workbook' that keeps track of inventory in a shop. There are 3 sheets in the workbook. The first one is the raw data which is 'Item Name', 'Initial Stock', 'Stock Used',...
2 votes
1 answer
3k views

Showing rounded integer values in a Pie Chart in Google Sheets without decimals (Pie Chart - Slicing Label does not work)

The proposed solution for the general question has been already asked here: How to change the values of a pie chart to absolute values instead of percentages in Google Sheets But it doesn't work for ...
0 votes
0 answers
28 views

How can I format my x-axis to include time in order from 6pm to 2am?

I want to create a scatterplot for Number of Days Late To School Each Month vs. Typical Bedtime from survey data provided by my stats students. However, my x axis "starts" at 12:00am and &...
1 vote
1 answer
2k views

How do you interpolate data in a horizontal range that's non-linear?

I've been told what I'm hoping to do is called 'spline interpolation'. I've imported monthly youtube channel viewership figures from google API. And I've layed out the dates and views in a horizontal ...
1 vote
0 answers
90 views

Can I replace percentages in legend with another value?

I would like to change the default percentages shown in a Google Sheets Pie Chart with the actual dollar values. Is that possible? I don't see anywhere to choose something other than the percentages. ...
2 votes
2 answers
3k views

Google Sheets Scatter chart: multiple data points at same X location

I have a dataset where I have on each row data associated with an item that has a name (alpha, beta, gamma in the example), as follows: I now want to create a scatter plot where the X axis ...
11 votes
4 answers
27k views

How to reduce number of X axis labels?

I have a chart with dates along the X axis, but the chart displays them quite close together, producing a rather ugly graph. How might I reduce the number of visible labels to increase the readability ...
1 vote
0 answers
46 views

Google sheets: Is it possible to have a chart automatically update each day based on the same cell?

I am trying to create a line chart in Google Sheets that automatically updates every day to show a value in a specific cell. For example, I have an accounting value in cell B11 - I want that to be ...
0 votes
1 answer
1k views

Unable to change Google Sheets data point format without changing other data points

I am trying to ensure that each bar in a horizontal bar chart in Google Sheets has its own unique color. Conventional wisdom seems to entail either select the chart --> left-click on the bar -->...
1 vote
1 answer
325 views

Stop Google Sheets from removing trailing zeros

Can anyone suggest a Google Sheets formula to stop removing trailing zeros? (but allow truncating to 6 digits after decimal? 00.000000 29.9918650 -93.958005 29.991865 -93.958005 (1mi:29.991865:-...
2 votes
1 answer
74 views

Google Sheets scatter plot stretches to fit my screen, how do I stop that?

I'm (unfortunately) stuck on my phone without access to a laptop most day, so when I'm messing around in Google Sheets, my scatter plots end up awfully stretched/squashed: As you can see the grid ...
7 votes
3 answers
6k views

How can I horizontally space data points on a chart when the dates are arbitrary?

Say I have events that occur on sporadic dates, like this: Date Qty 2022-01-01 100 2022-02-08 200 2022-06-17 150 2022-08-03 700 2023-01-27 300 I have rows for arbitrary days in Jan, Feb, June, ...
1 vote
1 answer
229 views

Google Sheets time sorting chart [closed]

I have a MailChimp data export in google sheets and I want to create some charts that can show the best time of day/day of the week based on my data for our mail outs when compared to open rate (%). I ...
0 votes
0 answers
19 views

Google Sheet Data and Pie Chart [duplicate]

I need to show on a pie chart the data in Column B as a % of data in Column A How can I do that? The chart calculates the data in Column A as a % of the total sum of column A.
0 votes
0 answers
17 views

Mulitlevel axis [duplicate]

I am looking for any idea on how to make a multilevel axis on Google Sheet like we can do on Excel so having on X Axis the year AND the month :
0 votes
1 answer
2k views

Google Sheets table of data wont create graph accurately?

So I am trying to convert some data into a scatter plot using Google Sheets. I have 2 problems: When I try and order the x and y so that the graph has x data on x and y on y it inverts it. May this ...
3 votes
1 answer
165 views

Making a bubble chart in Goggle Sheets for year-on-year comparison - ie year versus month?

I'd like to make a multi-series bubble chart from 17 years of sporadic data with Year on the Y axis and Month+Day on the X axis and the bubble size corresponding to each data point's value. I've ...
1 vote
0 answers
21 views

Calculating multiple means and then putting them in a graph but more complicated [closed]

Me and my sister love playing the sims and we want to analyze how much each painting you can make will earn. We made a spreadsheet containing the type of painting, the cost of the painting, the mood ...
4 votes
1 answer
12k views

How can I Set the Order on Items in a Chart Legend?

I have these two charts which pull the same data from the same table. The legend items appear in reverse order in the second chart. Anyone know how to make those match?

1
2 3 4 5