Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

60 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
12
votes
2answers
4k views

Statically positioned chart (ignore scroll)

I have a Google Sheets document 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 ...
3
votes
0answers
5k views

Showing percentages in google sheet bar chart

It looks like bar charts in Google Sheets won't support percentages. Is this correct? If so, how would a change the populating query that currently returns "count of"? A single cell used as the ...
3
votes
1answer
123 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
0answers
15 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?
2
votes
0answers
211 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:
2
votes
1answer
300 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
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 ...
1
vote
0answers
44 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://...
1
vote
0answers
18 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 ...
1
vote
0answers
228 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 ...
1
vote
0answers
14 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
vote
0answers
23 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 ...
1
vote
0answers
6 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 ...
1
vote
0answers
11 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!
1
vote
0answers
19 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 ...
1
vote
0answers
20 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 ...
1
vote
1answer
38 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 ...
1
vote
0answers
545 views

In Google sheets is it possible to have a combined chart with stacked columns?

I currently have a simple combined chart with a revenue line and columns. For what I am trying to communicate with this graph, I would really like to have stacked columns in addition to my revenue ...
1
vote
1answer
46 views

Google Sheets time sorting chart

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 ...
1
vote
1answer
349 views

Compare dates from two years in a graph when dates not identical in Google Sheets

I can’t figure out how to compare two data sets with date intervals form each year. Only the start and end date are the same days, the rest is spread over the period. And there can be more points in ...
1
vote
0answers
15 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 ...
1
vote
0answers
356 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 ...
1
vote
1answer
125 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('...
1
vote
0answers
444 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 (...
0
votes
0answers
7 views

How to combine two data points into one on a Google Sheets line chart?

I am trying to make a Google Sheets line chart. Why does this not work as a data range? A31:A69,A71:A94,D31:D68,=SUM(D69:D70),D71:D94 X-axis = column A (date) Y-axis = column D (dollars, numeric) Only ...
0
votes
0answers
18 views

Always use last completed row for pie chart

I have a Sheet onto which I add a line every week to record certain numbers in various category (columns). I would like to have a Pie chart display the current status of those categories. This means ...
0
votes
1answer
28 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',...
0
votes
0answers
11 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?
0
votes
1answer
22 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
0answers
7 views

How do I get uniform spacing for x-axis labels that are numerical values in Google Sheets?

I have a Google sheets line chart and would like to use a series as the labels for the x-axis in which the elements are even spaced along the x-axis; however the values in that series 1.1 2.1 3.1 4.1 ...
0
votes
0answers
23 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?
0
votes
0answers
12 views

How to only show Monthly results in Google Sheets Graph

Im trying to make this graph to only show the monthly results, but the specified Dates are also showing on it and I fear I will end up with a clunky, ugly graph. Ive tried changing the data to B2,B8,...
0
votes
0answers
18 views

Can't get chart to display weeks from specified day

I can't for the life of me get my chart to display every Monday (starting from 13/07, instead it displays every Sunday (starting with 12/07).The chart also starts with 6 data points (minor lines) and ...
0
votes
0answers
11 views

Google Sheets chart only shows first ~250 rows?

I have a stacked area chart with an x-axis from B8:B350 and two series from C8:C350 and D8:D350 (so data range B8:D350) but the data only displays the first ~250 rows which is September to May. Any ...
0
votes
0answers
12 views

How do I make a chart based on labeled values in Google Sheets?

I have a simple data set with nine values in Google Sheets. (Link here, screenshot follows.) Some questions about charts (Mockup at bottom): I can concatenate Columns A and B into a new column ...
0
votes
0answers
12 views

Plotting a chart when header is not immediately above first data point

Say I have these the following data: A B C 1 Yes No 2 8/10/12 56 17 3 8/11/12 44 69 4 8/12/12 71 15 5 8/13/12 56 44 6 8/14/12 ...
0
votes
0answers
14 views

Visualize time events, one line per day

In Google Sheets, I have a list of events like this ("Date time" format): 4/13/2020 11:11:32 4/13/2020 11:40:54 4/13/2020 12:16:28 4/13/2020 13:07:01 4/14/2020 11:33:26 4/14/2020 12:04:39 4/14/2020 ...
0
votes
1answer
21 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
1answer
1k 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 ...
0
votes
0answers
15 views

How to make one of lines continuous in Google Sheets?

I drew fitting plot in Google Sheet, but both series were depicted by separate dots How to make red series continuous? If I choose edit, I get only settings for dots
0
votes
0answers
27 views

How to create chart until today's date, automatically, every day?

On a row from left to write there are dates (daily). Manually written, but automatically populated. On another row, there are formulated numbers (formulated for each date). The chart gets those ...
0
votes
0answers
27 views

Creating a horizontal decision tree in Google Sheets - Can the one flip the default one?

I want to create a horizontal decision tree in Google Sheets - the default one is vertical - moving from top to down, I want mine to be like a decision tree from left to right branching out. How can ...
0
votes
0answers
11 views

Finding a cell value based on row and column

I have a little problem that might not be solved just with formulas. And I am not so advanced in JavaScript yet. I have a list of products, our salesmen, customers and time when and how much the are ...
0
votes
0answers
168 views

Google Sheets: Histogram of time data (axis numbering)

I've tried making a histogram of my data, which looks like so: 12:00:02 PM 3:00:00 PM 12:30:00 PM 12:30:00 PM 2:00:00 PM 3:00:00 AM … I highlighted the data and selected insert > chart > ...
0
votes
1answer
1k views

Google Sheets: Fill out dates and replace blank cells with zeroes

I'm trying to make a timeline graph of seed sales, and right now it's almost completely unuseable: I think there are two reasons for this: Not all dates have values associated with them, and ...
0
votes
1answer
572 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 ...
0
votes
1answer
249 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
1answer
959 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 ...
0
votes
1answer
329 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 -->...
0
votes
1answer
18 views

Process visualization based on data

I am trying to use a Google spreadsheet to visualize a customer journey. I am trying to create the following graphic: I have created the following example spreadsheet: https://docs.google.com/...