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
13
votes
3answers
6k 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
1answer
125 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
299 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
301 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
4k 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
16 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 ...
1
vote
0answers
83 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
21 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
526 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
15 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
28 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
286 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 > ...
1
vote
0answers
23 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
1answer
1k 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
75 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
847 views

How to preserve colors of each series from changing when inserting new data in Chart Editor?

This issue occurs in every chart type. As an example, I have a pie chart created from a long table of data where each column is assigned a specific text color, so each slice of the pie corresponds to ...
1
vote
1answer
437 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
379 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
890 views

Chart labels disappear (stays outside the graph area) Google sheets

Really count on your help here, as it seems like I tried everything already. Take a look at the graph: the last value label disappears (the location is right on the inner border of the graph, so the ...
1
vote
1answer
129 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
467 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
1answer
17 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 ...
0
votes
0answers
7 views

Show label when hovering over point in diagram

My chart is quite crowded but I need to be able to look up the manual labels assigned to each point. Is there a way to make Google spreadsheet show the manual label upon hovering over the point with ...
0
votes
0answers
8 views

Add more numbers in Vertical axis

Ideally, I'd like it to have percentages of 10. 0% - 10% - 20% - 30%, etc. But I'm not finding a way to customize this. Can anyone help?
0
votes
0answers
10 views

Creating graphs from own formula

We are all familiar with the Y=mx+b Now I have the following values that I want to use in this formula to create a graph in Google Sheets: m = slope k = exponent b = y-intercept (vertical shift) c = x-...
0
votes
0answers
19 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
23 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
59 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
49 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
31 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
9 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
39 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
15 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
1answer
22 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
877 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
323 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
1k 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
460 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
59 views

Graphing two lines in Google Sheets based on values in first column

I'm trying to create two lines on the same graph, with one being 'Line A' based on Data labeled 'A' and 'Line B' based on B. The X-axis would be the date and would expand over time as more entries ...
0
votes
1answer
43 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 ...
0
votes
1answer
26 views

Bar Chart Merge 2 columns in a single bar

I have the following table, I want to generate a bar chart where for each year I can see a single bar, including both Cash and Credit. Today I only see this: Link here