Chart on a separate sheet.

[JanKos]

Will there ever be an option to put the chart on a separate sheet in the chart wizard? Moving charts using the shortcuts ctrl+x/ctrl+v is cumbersome and not very intuitive. Otherwise, I would like to be able to decide where the charts should be placed while creating a chart. Current approach creates another problem with printing charts. Again, this solution is inefficient because each graph must be selected separately and the scaling must be set manually.

[anon73440385]

Please take a minute and read this Introduction - Feature Request and what it states about where Feature Requests should go to.

[Zizi64]

Try it:

• Do NOT select the Chart data range, but activate the ANOTHER sheet.
• Click on a cell on the sheet where you want to put the chart to.
• Click on the Chart icon of the toolbar.
• Select the chart type, then NEXT.
• Click on the Icon near the Data Range edit box, and “Select data range” on the relevant sheet.
• Complete the rest of the settings.
• Done

[JanKos]

Thanks a lot. This way is much better than cutting and pasting to another sheet. However, it would be nice if such an option appeared in the chart wizzard.

[JNygren]

What does “activate the ANOTHER sheet” mean? What is the ANOTHER sheet?

[LeroyG]

@JNygren

ANOTHER sheet?

The tabs (generally) at the bottom of the spreadsheet (Sheet1, Sheet2, etc.)

[Zizi64]

@JNygren

What does “activate the ANOTHER sheet” mean? What is the ANOTHER sheet?

The sheet where you want to put the chart to.

[JNygren]

Ah, I see. What you’re saying is ‘add a new sheet where you want to put your chart’, if it doesn’t already exist. And it appears the rest of the instructions just create a new chart on this sheet.

I misunderstood. I was searching for how to move an EXISTING chart to a new sheet.

I agree with what JanKos said:

@JanKos

Moving charts using the shortcuts ctrl+x/ctrl+v is cumbersome and not very intuitive.

[LeroyG]

@JNygren

how to move an EXISTING chart to a new sheet

See:

Copying Chart in Calc

I found a faulty method, so edited my answer accordingly: You have copied from Sheet1, inserted/moved Sheet2 (or Sheet3) to the left of Sheet1 tab, and pasted. Solutions: If Sheet2 tab would be to the left of Sheet1 tab: Copy from Sheet1 after inserting/moving Sheet2 If you already copied from Sheet1, and Sheet2 (or Sheet3) tab is (are) to the left of Sheet1 tab: Move Sheet2 (and Sheet3) tab(s) to the right of Sheet1 tab Paste Reorder the sheet tabs In my examples, Sheet1 name could h…

Copy tab in Calc with charts and have the charts link to data in the new tab

Create the new sheet, then copy and paste the data range with the chart. When pasting, if the new sheet is to the left of the original sheet, the chart data will remain linked to the original one. So, you can paste then move the sheet to the left. I am almost sure that there is a bug report about that. I can’t reproduce the problem if copying the whole sheet as described in my answer. Tested with 7.1.8.1 and 7.3.2.2 on Windows 7.