I have a chart of two series, Sheet1!Foo and Sheet2!Foo. They are named in the chart the same way – Foo. How can I include the sheet name in the series name?
Google Sheets Chart – Make Google Spreadsheet Chart Use Tab and Column Name as Series Header
google sheets
Related Solutions
Comment
Example
I've created an example file for you: how do I prevent “Other” in the legend?
Update
I've done some research and found out the following in which the behavior can be resolved if shown:
- Choose an exact range in the chart: I2:I107
- Delete the remaining empty rows, in your sheet
I assume you know how to make a chart where the X is date, Y is your moving average (if you have the value).
Used Google searches to find:
- How to sum up rows above - modified to select previous column and to include current row
=SUM(INDIRECT(ADDRESS(1,COLUMN()-1)&":"&ADDRESS(ROW(),COLUMN()-1)))
- Row function - Row function used to display current row number minus 1 to adjust for a row header
=ROW()-1
- Divide SumRowsAbove with RowNum (C/D) which returns your definition of MovingAverage (E).
Related Topic
- Google-sheets – Google Sheets, formula, reference to variable sheets
- Google-sheets – Google Sheets – summing numbers across a spreadsheet depending on the Column header
- Google-sheets – Stacking time series in Google Sheet Combo chart
- Google-sheets – How to rename a series in Google Sheets chart
- Google-sheets – How do i use the query in google sheets to return N results from each tab
- Google-sheets – Copy value from another column based on cell value
Best Answer
A chart is based on the data contained in the Data Range from which it is created, and nothing else. Sheet name is not a part of the picture. In order for sheet name to appear within the chart, it has to appear in the header row/column within chart's range. This can be done automatically by a script or a custom function, but with two sheets, it's far easier to rename the headers manually.