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
4 votes
0 answers
726 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
318 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
170 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
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 ...
user15571's user avatar
2 votes
1 answer
109 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
2k 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
  • 371
2 votes
1 answer
18 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
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
  • 155
2 votes
0 answers
24 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
2k 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
85 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
530 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
647 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
  • 151
1 vote
0 answers
31 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. ...
user avatar
1 vote
0 answers
30 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 ...
DaddyJunkee's user avatar
1 vote
0 answers
22 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
  • 43
1 vote
2 answers
2k 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
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 ...
Rey San Pascual's user avatar
1 vote
0 answers
296 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
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.
user130306's user avatar
1 vote
0 answers
436 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
0 answers
439 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
871 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
833 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
76 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
17 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
189 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
69 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
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
122 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
0 answers
25 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 &...
Jennifer Preissel's user avatar
0 votes
1 answer
360 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
43 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
1 answer
321 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
184 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
172 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
321 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
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()) ....
Dolatsang Parmar's user avatar
0 votes
1 answer
70 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
751 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
  • 710
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
260 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