214 questions
Filter by
Sorted by
Tagged with
36 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. ...
9 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.
11 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 :
• 1
90 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 ...
1 vote
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 ...
• 11
93 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 ...
• 103
133 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 ...
• 449
30 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 ...
1 vote
113 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 ...
• 113
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 ...
1 vote
517 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 ...
• 11
227 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 ...
271 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 ...
1 vote
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 ...
• 361
1 vote
1k 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 ...
• 113
1 vote
365 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 ...
• 13
1 vote
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 ...
• 41
1 vote
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 ...
• 111
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 ...
1 vote
218 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 ...
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
161 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 ...
• 123
257 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 ...
• 101
119 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 ...
1 vote
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.
• 111
89 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 ...
• 101
1 vote
331 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-------...
160 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 ...
774 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 ...
3k 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, ...
• 171
58 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 ...
• 103
37 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 ...
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 ...
1 vote
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(...
• 135
1 vote
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 ...
• 135
258 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 ...
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()) ....
733 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 ...
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 ...
148 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 ...
945 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 ...
594 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
357 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://...
• 109
1 vote
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 ...
13k 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 / ...
384 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 ...
• 21
683 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',...
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?
• 660
1k views