Saturday, June 8, 2019

Google Docs - spreadsheet - insert chart on another sheet (updated)

To insert a chart for your spreadsheet data, you can highlight the wanted cells and select menu Insert|Chart. The new chart will be put somewhere on the same sheet of the data.

If you click on the chart, a vertical ellipsis icon will be shown at the top right corner.

 Click on the ellipsis icon and choose the "Move to own sheet..." option:


By selecting its menu Move to own sheet..., you can move the chart to another sheet. The chart will have its own sheet and it will fill the whole new sheet.

This may not be what you want. Sometimes, you want a chart sheet which contains several charts representing data from other sheets. To do that, you can add a new sheet first by clicking the Add Sheet button at the bottom-left corner.

Select the new sheet. Insert a new chart by menu Insert|Chart. Double click on the new blank chart to show the Chart editor as the right sidebar. In the Chart editor sidebar, you need to manually input what data you want to use. If the data are from Sheet1, you need to add Sheet1! right before the cells range.

Now you have a chart for the data from Sheet1. You can add more charts for the data from different sheets in this way, so that you can have a single "chart sheet" for the whole document.


Sean Brown said...

Thank you. This works.

Anonymous said...

How can I do this with data from "Another worksheet" ?

Anonymous said...

@Anonymous: Import range, follow step, hide sheet.

Get This <