[Solved] Inserting A Chart Into A New Worksheet

[Eroica]

With earlier versions of Calc, Insert Chart... brought up the Autoformat dialog box. This allowed one to choose the worksheet in which the finished chart appears.

I now use version 2.4 and when I choose Insert Chart... a Chart Wizard appears which does not incluse this option.

How do I insure that the finished chart will appear in a different sheet to the one in which the data are located?

Thank you.

[acknak]

You probably realize this already, but you can always create the chart alongside the data, then cut/paste it to another sheet.

[jrkrideau]

With earlier versions of Calc, Insert Chart... brought up the Autoformat dialog box. This allowed one to choose the worksheet in which the finished chart appears.

I now use version 2.4 and when I choose Insert Chart... a Chart Wizard appears which does not incluse this option.

How do I insure that the finished chart will appear in a different sheet to the one in which the data are located?

Thank you.

Before selecting data, create the chart on the sheet where you want it and then select the data.

Start Wizard ; Get to Select data range, click on the Select Data range button ( right of the white bar) and then just click on whatever sheet that contains the data and select the data.

[Eroica]

Before selecting data, create the chart on the sheet where you want it and then select the data.

Start Wizard ; Get to Select data range, click on the Select Data range button ( right of the white bar) and then just click on whatever sheet that contains the data and select the data.

Thank you, Rideaujrk! That solved my problem. (Sorry for the delay in replying - I never got my email telling me that anyone had replied to my query!)

Eroica