Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [google-sheets-charts]

For questions specifically about charts/graphs created in Google Sheets

Filter by
Sorted by
Tagged with
0 votes
3 answers
30 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 ...
user avatar
  • 103
0 votes
1 answer
28 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 ...
user avatar
  • 101
0 votes
1 answer
30 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 ...
user avatar
0 votes
1 answer
41 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.
user avatar
0 votes
1 answer
25 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 ...
user avatar
  • 101
0 votes
0 answers
33 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-------...
user avatar
0 votes
0 answers
43 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 ...
user avatar
0 votes
1 answer
17 views

How to combine cells of data in Googlesheet to a single/consolidate row and remove duplicates?

I'm trying to consolidate all the invoices that we get from the same contractor to a single row that will have the business name, all the memos/invoices for the week in one cell along with the added ...
user avatar
0 votes
0 answers
22 views

Define the x axis in a chart using two ranges

I have this data in Google Sheets, x1 y1 x2 y2 0 0 9 0 1 2 7 -4 2 2 5 -4 3 0 3 0 and I'm trying to produce a graph (the y-axis is inverted, ...
user avatar
  • 111
0 votes
1 answer
19 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 ...
user avatar
0 votes
0 answers
16 views

Google Sheets– Scatter chart comparing two variables

I'm trying to compare two different variables, one as x and one as y, for 30 different countries on the same graph. Basically, I'm trying to get it to look like the graph below, only with several ...
user avatar
  • 1
0 votes
0 answers
84 views

How do I change textStyle of labels in radar chart?

I'm making a radar chart using Google Apps Script and I don't know how to change the font size of the "labels" (see the picture). So far I've tried hAxis, ticks, legend and none of them ...
user avatar
  • 3
0 votes
1 answer
63 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, ...
user avatar
0 votes
0 answers
11 views

Pivoting 3-dimensional data

I have this 3-dimensional data and would like to have a chart to view each person's data from their category (Approach-Meet-Master). Any help? Approach Meet Master UA1 ...
user avatar
  • 1
0 votes
0 answers
19 views

Line Chart with series dynamically generated from cell values

I have the following data: https://docs.google.com/spreadsheets/d/1odEoSCiz897B3Qm_GCOXQkxyE5JP504blizhDkC4y4o/edit?usp=sharing I wanted a line chart where the x-axis was the 'date' from column A and ...
user avatar
  • 101
0 votes
1 answer
14 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 ...
user avatar
  • 103
0 votes
1 answer
20 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 ...
user avatar
0 votes
1 answer
9 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 ...
user avatar
  • 1
0 votes
0 answers
478 views

How to reverse the y-axis in google sheets when the y-axis is time of day?

So I'm trying to make a Marey graph, and I have it mostly figured out, but I can't figure out how to get it so that 12 AM is followed by 1 AM and so on, currently it starts at 12 AM, then goes to 11 ...
user avatar
0 votes
1 answer
104 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(...
user avatar
  • 5
0 votes
2 answers
434 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 ...
user avatar
  • 5
0 votes
1 answer
29 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 ...
user avatar
  • 1
0 votes
0 answers
15 views

Sheets histogram not displaying bucket values

Given a series of values (range:1->7.989000E-11) to create a histogram. Horizontal max set to .0000001 (with option selected Allow bounds to hide data). I try to view the ranges of the various ...
user avatar
0 votes
1 answer
63 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()) ...
user avatar
-1 votes
1 answer
195 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 ...
user avatar
0 votes
1 answer
37 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 ...
user avatar
0 votes
1 answer
36 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 ...
user avatar
0 votes
1 answer
408 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 ...
user avatar
2 votes
0 answers
65 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 ...
user avatar
1 vote
0 answers
165 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://...
user avatar
  • 109
1 vote
0 answers
40 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 ...
user avatar
0 votes
1 answer
3k 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 / ...
user avatar
2 votes
1 answer
248 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 ...
user avatar
  • 21
0 votes
1 answer
276 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',...
user avatar
0 votes
0 answers
442 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?
user avatar
  • 550
0 votes
1 answer
555 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 | +----+---+---+----+ | ...
user avatar
  • 13
0 votes
0 answers
20 views

Chart with multiple groups [duplicate]

I got the following table on Google Sheets. I want the first column to represent the groups in x axis. The 2nd column is supposed to be the a group in a certain x value lets say I have: 8 3 22 8 4 ...
user avatar
  • 13
1 vote
0 answers
235 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?
user avatar
0 votes
1 answer
80 views

Histogram for scattered dates (some days have no row, they should still show up, with height zero)

I have this data (as you can see I did zero pushups on the 21st/23rd/24th): Date Pushups 9/20/2020 150 9/22/2020 100 9/25/2020 200 What is the easiest way to make a histogram with this data? ...
user avatar
  • 8,468
-1 votes
2 answers
59 views

Add % sign in Data Labels Google Sheets [closed]

I have a simple chart in Google Sheets. Currently, the data labels are just numbers. I want to append a % sign infront of each value. How can I do so? https://docs.google.com/spreadsheets/d/1wyubPje-e-...
user avatar
  • 99
0 votes
1 answer
75 views

Copy from individual cell in Google Sheets Table Chart

I'm using appscript to build and insert a table chart into a sheet when a button has been pushed. var chart = sheet.newChart() .setChartType(Charts.ChartType.TABLE) .addRange(outrange2) .setPosition(2,...
user avatar
0 votes
1 answer
49 views

How to make time series chart, where all rows are labelled and dates are not unique?

Say I have some data like so | Month | Count | Type | | | |-------|-------|------|--- |--- | | 1 | 2 | A | | | | 1 | 3 | B | | | | 2 | 1 | A | | ...
user avatar
1 vote
1 answer
467 views

Google Sheets: aggregate and extrapolate irregular data over time

I have a list in which I now-and-then (no fixed interval) enter the available budget. Most of all I want to extrapolate this to a future trend of the coming 10 years. (no rocket science, more of an ...
user avatar
2 votes
0 answers
18 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?
user avatar
1 vote
0 answers
615 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 ...
user avatar
  • 111
1 vote
0 answers
354 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?
user avatar
  • 11
1 vote
0 answers
55 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 ...
user avatar
  • 111
1 vote
0 answers
13 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 ...
user avatar
  • 11
1 vote
1 answer
61 views

Google Sheets graph jump by 1 on the horizontal axis

How can I change the graph’s horizontal axis to show a jump by 1 instead of 2?
user avatar
1 vote
1 answer
5k views

How do I format the horizontal axis labels on a Google Sheets scatter plot?

The settings for the vertical axis on a Google Sheets scatter plot provide an option for selecting or customizing a format for the labels, but no corresponding option is provided for the horizontal ...
user avatar
  • 550

1
2 3 4 5