[Issue] Create Charts in New Data Sheets

[souhome]

Welcome beginner. What is your question or comment?
Please try to briefly and clearly tell us: What you want, What you tried, and What happened.
-----------------------------------------------------------------------------------------------------------
I have insert a chart in openoffice calc ,but I would like to ask you if it is possible with openoffice calc to insert a chart but as a new sheet as this is an option in ms office excel?If yes how can i do it automatically?

thanking you in advance

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply. (Bhikkhu Pesala, Moderator)

[souhome]

from a table of data i created a chart but in was automatically placed in the current sheet.In MS office we get a question if we want to create the created chart as a new data sheet or as an object in the current data sheet

[jrkrideau]

from a table of data i created a chart but in was automatically placed in the current sheet.In MS office we get a question if we want to create the created chart as a new data sheet or as an object in the current data sheet

One way to do this is to insert an empty chart in the new sheet, I mean don't select any data and then enter the data series from the other sheet in the Wizard.

[souhome]

"One way to do this is to insert an empty chart in the new sheet, I mean don't select any data and then enter the data series from the other sheet in the Wizard." this is not working!!!If i ceate a chart in the current sheet and copied or cut and paste it in a new sheet is working but it is a little bit complicated compared to the function of the ms office excel!

[Dave]

it is a little bit complicated compared to the function of the ms office excel!

Darn. If you hadn't said that I was about to show you how to do it. You'd best stick with Excel if you've already paid for it, I think.

David.

[Hagar Delest]

For information: Issue 5736 - Create chart as a sheet (chart only sheet, chartsheet). You should subscribe and vote for it (up to 2 votes per issue).