Hi There! As far as I know, there was (or still is?) a Microsoft Office version of Excel that allows Charts/Diagrams to be an own seperate Tab. The Data is written in standard Chart fields as usual, but when it comes to the Diagram-Assistant, you can choose wether the diagram will be shown as a picture overlay in the same tab or as an own seperate Tab. That could be very helpful, when you have data that is possible to be displayed on different ways/charts, so there would be more overview for the diagrams. (I hope you understand my english; it's not my native language). Thanks! Gerry claimer@hotmail.com
You can cut/paste the chart from one sheet into another. Do we need controls for this simple action in the wizard? It would have to be a selection with existing sheets plus something to add new sheet. For sake of simplicity we should abstain from this feature.
@Heiko Tietze I understand what you mean, but I guess that is not what I meant in my suggestion... To copy/paste a chart from one sheet to another is no problem... I thought that it would be helpful to create a chart AS a single / separate tab with no overlay-design on a sheet - the chart itself should be the sheet. If you have a very detailed database that you like to display in various charts (or parts of the data in several relationships to another), you have to create for example four or five charts, that you can only display as overlay-fields above the sheet, at this moment. Instead of this, it could be more convenient to make a chart being a separate tab - each of them. So you have one data sheet in which you can input your data and four or five chart-sheets that show the analysis as charts in separate sheets, that have no grid for data input...
See https://wiki.documentfoundation.org/Development/Calc#Multiple_sheet_types
*** Bug 120165 has been marked as a duplicate of this bug. ***
*** Bug 122505 has been marked as a duplicate of this bug. ***