Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

58 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
0 answers
607 views

How do I specify a consistent interval for a date-range axis in a Google Sheet Chart

I have a Google Sheet with a set of deposits and withdrawls and the running balance. I have added a chart to the sheet, so I can visualize what the balance has been over time and when deposits or ...
Todd Powers's user avatar
3 votes
1 answer
312 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, ...
csswizardry's user avatar
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 ...
Shazz's user avatar
  • 131
3 votes
1 answer
5k 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 ...
user15571's user avatar
2 votes
1 answer
39 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. ...
The Buggser's user avatar
2 votes
1 answer
17 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
user299539's user avatar
2 votes
0 answers
22 views

Customize point style in scatter chart [Google Sheets]

Is there a way to add new point shapes (import new symbols) in Google Sheets charts? Also, can I customize there color fills, or remove the infill color?
Kajo's user avatar
  • 121
2 votes
0 answers
1k views

How can I create a violin plot in Google Spreadsheets?

How can I create a violin plot in Google Spreadsheets? Example of violin plot:
Franck Dernoncourt's user avatar
2 votes
0 answers
84 views

Google Sheets: move a chart and still have it update from original data/arrays?

Can you move or copy a chart in Google Sheets into another EXISTING sheet and have it still update form the original data arrays? I know you can move a chart into its own sheet, but I'm looking to ...
hrrywllm's user avatar
2 votes
0 answers
520 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 ...
alenotari6's user avatar
2 votes
0 answers
629 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 (...
Scott's user avatar
  • 141
1 vote
1 answer
1k 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 ...
chelder's user avatar
  • 361
1 vote
0 answers
19 views

Unlimited range for plot in Sheets

I would like to create a plot whose range extends as new columns of data are added. I have read that dynamic named ranges are not available in Sheets, and that named ranges are not allowed in plot ...
jmichel's user avatar
  • 41
1 vote
2 answers
1k views

Google sheets chart to compare two values every year

I'm trying to build a chart within google sheets to compare my portfolio contributions vs yearly allowed maximum limits. My data looks like the below. I'm not sure which chart to make use of to ...
kunaguvarun's user avatar
1 vote
0 answers
221 views

How to prevent Google Sheets setting chart axis option "Treat Labels as Text" for imported xlsx?

I've imported an Excel spreadsheet containing a chart into Google Sheets. Excel displays my axis like this: After importing the xlsx into Google Sheets the Axis displays like this: I can get Google ...
Chris Snow's user avatar
1 vote
1 answer
1k 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.
user130306's user avatar
1 vote
0 answers
334 views

How can I plot points on a 1d number line in Google Sheets?

I'd like to create a 1-dimensional chart in Google Sheets. The chart effectively plots values on a number line like so: A B C D E |-------------O-------...
joelittlejohn's user avatar
1 vote
2 answers
2k 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 ...
TLSO's user avatar
  • 135
1 vote
0 answers
362 views

Create circle packing charts in Google Sheets

I am trying to find a way to add a circle packing chart to a Google Sheet, using the data in a Google Sheet as its data source. The only possibility I have found is this from DHUMANITIES http://...
xyz333's user avatar
  • 109
1 vote
0 answers
52 views

Capturing events on embedded charts within Google Sheets

I am trying to embedded column chart in Google sheets and would like to capture events like which column was clicked, then use the info to highlight certain cells. Is that even possible in embedded ...
Naveen Rawat's user avatar
1 vote
0 answers
754 views

How to make median appear in a box plot chart in Google Sheet?

I want to know how can I make the median line appear in the box plot chart?
WindBreeze's user avatar
1 vote
0 answers
788 views

Progress bar with Bar Chart in Google Sheets

I have a 2 tasks that I would like to keep track of my progress in Google Sheets with a percentage bar chart. Google Charts is not allowing me to separate the data into two series. They have the same ...
K. Shores's user avatar
  • 111
1 vote
0 answers
75 views

Link chart heading to cell

I would like the main heading of a Google Sheets chart to change dynamically by linking it to the value of a cell. The header input field does however not seem to handle formulas like =I4, it just ...
qnyz's user avatar
  • 111
1 vote
0 answers
16 views

How to automatically add data series to line chart when new row of data added to underlying sheet?

I have a line chart where the X-axis is Day of Week and Y-axis is a count. The underlying sheet has Sunday dates in column A, where each row is one week apart, and columns B-H have count values for ...
ryco's user avatar
  • 11
1 vote
1 answer
152 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 ...
Maroon's user avatar
  • 161
1 vote
0 answers
64 views

Multiple y-values for one x value

I'm trying to graph the following values: 0degr 0.24-0.27 20degr 0.22-0.28 40degr 0.22 60degr 0.2 How do I graph a range such as "0.24-0.27" in google sheets? Thank you!
Anthony Gray's user avatar
1 vote
0 answers
36 views

Google Sheets Area Graph(s)

I need (want) to create a Google Sheets Area Graph (Chart). The Graph/Chart will represent "Date"s. I need the Xaxis to be the dates (as days) between these start and end dates: 01/27/2020, 4/25/2020 ...
WorldTraveler's user avatar
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 ...
WildVirtue's user avatar
1 vote
1 answer
53 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 ...
Keenan Burke-Pitts's user avatar
1 vote
1 answer
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 ...
Nicolas's user avatar
  • 111
1 vote
0 answers
29 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 ...
Ramon Suarez's user avatar
1 vote
1 answer
2k 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 ...
Neerkoli's user avatar
  • 111
1 vote
1 answer
115 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 ...
Saturnix's user avatar
  • 131
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('...
Fredrik's user avatar
  • 11
0 votes
1 answer
99 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 ...
dijxtra's user avatar
  • 103
0 votes
1 answer
32 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 ...
Gabby's user avatar
  • 1
0 votes
0 answers
12 views

Google Sheets: stack week value into one month bar

For simplicity sake, let's say I have this data: Mon $10 Tue $12 Wed $9 Thu $10 Mon $11 Tue $11 Wed $12 Thu $9 ... I want to create a stacked chart in Google Sheets. In the first column (labelled ...
Grizzly FoxCat's user avatar
0 votes
1 answer
1k 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 ...
Rey San Pascual's user avatar
0 votes
1 answer
264 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 ...
philippos's user avatar
  • 101
0 votes
0 answers
162 views

Stacked Bar Graphs with ‘Nested Data’ for two Y-Axis Categories

Re: Stacked Bar Graphs with ‘Nested Data’ for two Y-Axis Categories Forgive me if I have a hard time articulating our need. I have two data sets that have the following content: Number of Placements ...
Mike Newman's user avatar
0 votes
1 answer
148 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 ...
Tania's user avatar
  • 1
0 votes
1 answer
261 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 ...
DaiMi's user avatar
  • 1
0 votes
1 answer
1k 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()) ....
Dolatsang Parmar's user avatar
0 votes
1 answer
59 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 ...
John Bachir's user avatar
0 votes
1 answer
687 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',...
Maruwan's user avatar
0 votes
0 answers
1k views

How do I set the font for a published Google Sheets chart?

Google Sheets supports the publishing of interactive charts, but the resulting charts do not use the font set in the sheet. How do I set the font for a published Google Sheets chart?
orome's user avatar
  • 660
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 | +----+---+---+----+ | ...
Or24's user avatar
  • 13
0 votes
1 answer
1k 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 ...
patricktokeeffe's user avatar
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 -->...
Shadow43375's user avatar
0 votes
1 answer
194 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 ...
Peter Pan's user avatar