Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
1 vote
0 answers
21 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
1 answer
85 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:-...
Most Interesting Man In World's user avatar
1 vote
1 answer
35 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 ...
AncientSwordRage's user avatar
2 votes
1 answer
82 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
0 votes
0 answers
13 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.
Thomy's user avatar
  • 1
0 votes
0 answers
12 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 :
Rod's user avatar
  • 1
3 votes
1 answer
137 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 ...
flyhigher's user avatar
1 vote
0 answers
20 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 ...
Riley's user avatar
  • 11
0 votes
1 answer
246 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
2 votes
1 answer
192 views

Google Sheets stacked bar chart showing 1 extra value and legend

Consider this Google Sheet: 6/30/2020 1/1/2021 1/1/2022 Consultant 3 4 6 Manager 0 1 1 Administrator 0 0 1 When I ...
Adam's user avatar
  • 449
0 votes
1 answer
41 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
1 vote
1 answer
153 views

Time series plot with category names as text

Let us say I have data like this for a spend summary sheet: Date Amount Category 03/31/2023 20.0 Food 03/31/2023 23.12 Coffee 03/31/2023 21.01 Movie 04/01/2023 10.0 Coffee 04/01/2023 12.0 Coffee ...
OlorinIstari's user avatar
0 votes
0 answers
14 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
1 vote
1 answer
1k 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 ...
Ashenden's user avatar
0 votes
1 answer
396 views

Google Sheets, coloring a line depending on another column (conditional formatting for lines)

Imagine I have a table like the following. Column A is the x-axis, e.g. time. Column B is some condition, e.g. 1 and 0 for yes and no or true and false. Column C has the y-values. I'd like to create ...
Michael Fischer's user avatar
0 votes
2 answers
584 views

How to automatically plot multiple series from values in a column

In Google Sheets, I know I can plot multiple series into a chart by manually adding a series and selecting/specifying the source data for each series. But is it possible to use a third column to ...
Jonathan Cakes'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
1 vote
1 answer
2k views

How to chart a sum of categorised values

I'm trying to figure out how to chart this in Google Sheets. Each segment of the pie chart should be the sum of each different "Type", e.g. there should only be one pie segment per type. I ...
Issung's user avatar
  • 113
1 vote
1 answer
648 views

How to Change Percentage Precision on Google Sheets Scatter Chart

I have made a scatter chart on Google Sheets from two columns of data. One column labeled "Pre-EO Remediation Rate" and one column labeled "Length of Pathway (Semesters)". A sample ...
Jetninja'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
0 votes
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
269 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
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
0 votes
3 answers
245 views

Making a graph from data of one out every n lines

I have data that comes in batches of N values ("Y" values if you like) for a given index (or "X" value if you like). How to make N separate series in my graph for each entry of a ...
Charles's user avatar
  • 123
0 votes
1 answer
303 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
1 answer
140 views

Why do my data points end up in the wrong places in my graph?

So I am trying to insert a vertical line in my graph in Google Sheets, by following the solution given here: https://stackoverflow.com/questions/58026200/add-a-vertical-line-to-google-sheet-line-chart ...
cellkluster'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
0 votes
1 answer
124 views

Group occurrences and combine values for Line Chart

I want to create a chart that counts occurrences from two different columns which might not have the same values. Here is a sample data: Be aware that the unique values might not be the same in each ...
Ícaro's user avatar
  • 101
1 vote
0 answers
403 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
0 votes
0 answers
180 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
-1 votes
1 answer
1k views

How can I change the min and max value of vertical axis in chart?

I want the vertical axis to range between 75 and 125. The min should be 75 and the max should be 125. 0 to 125 range is automatically generated. The highest data point is 107 and the lowest data point ...
Vaibhav Sharan's user avatar
7 votes
3 answers
4k 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, ...
Cam Jackson's user avatar
0 votes
1 answer
81 views

How to supply filtered series (data range) to chart?

I have a table with X-Y values for two types of measurements, I want to draw two graph lines on a chart for each of the type (without modification of data in the sheet) x-values y-values type 0 5 A ...
glaz666's user avatar
  • 103
0 votes
1 answer
46 views

Is there a way to track the frequency of a relationship between two columns?

I have two columns in a spread sheet where column A tracks about 100 different categories. In Column B, I have a formula that maps specific categories in Column A to one of 10 separate categories in ...
Andrew Kim's user avatar
0 votes
1 answer
164 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
1 vote
1 answer
2k views

Google Sheets: how to reference a range of cells for charts using a formula?

I'm trying to make a chart always take the range from the first 8 cells within a column without updating the range when a new row is added above the range. You could use something like "=INDIRECT(...
TLSO's user avatar
  • 145
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
  • 145
0 votes
1 answer
297 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
-1 votes
1 answer
830 views

Google Sheets Pie Graph Aggregation Merges Completely Different Categories

I've been trying to make a basic chart in google sheets that puts together the time taken for various activities to make a pie chart. Since the same activities appear multiple times I need to ...
Ashvin Kannan's user avatar
0 votes
1 answer
65 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
184 views

Plotting gigantic values + smaller values on the same Google Sheets chart?

I'm trying to plot a chart that includes one data set in billions, another in millions, and a third in thousands. What is the most efficient/elegant way to do this using google sheets without the ...
verve88's user avatar
0 votes
1 answer
1k views

Cumulative Timeline Plot Google Sheets

To make the job application process a bit more fun on the side, I am gathering some statistics on it. I would love to plot "number of applications submitted over time". I am limited to ...
Philipp Stephan's user avatar
3 votes
0 answers
703 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
1 vote
0 answers
406 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
3 votes
1 answer
15k views

How to overlay two charts?

In Google Sheets, I need two sets to data to appear on the same chart. One needs to be a scatter charts and the other needs to be a line chart. Both sets of data have the same x and y axis data / ...
StackOverflowNewbie's user avatar
2 votes
1 answer
432 views

How do I extract specific value from a single cell on Google Sheets

I'd like to get respective data into each cell without the key and punctuations. Each cell must display only the value extracted from the properties column. I've tried to go to Data>split text to ...
Yogi's user avatar
  • 21
0 votes
1 answer
733 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

1
2 3 4 5