Created attachment 74792 [details] image of chart wizard with indication where the location choice could be shown Problem description: Calc offers only a chart being on the same sheet as the data. Although copying a chart on a new sheet and expand it full window size is possible and maintain the links to the data. However, this takes a lot of work and reduces productivity. Solution: Enable Calc to let users choose location of charts can be selected - beside data only - in a separate sheet only (like MS EXCEL) - beside data AND in a separate sheet. (not available in EXCEL thus a unique feature of Calc) Default: beside data Location of the new feature: at the bottom of the chart wizard; see attached image, yellow marked text The idea came up in AskLibO http://ask.libreoffice.org/en/question/11775/how-can-i-put-a-chart-on-a-separate-sheet-in-calc/#comment-12087 Operating System: Windows XP Version: 3.6.5.2 release
I think we are talking about something similar as we already have for the pivot table. There we have a selector "Results to", where it can be selected where the pivot table should appear. @bugquestcontri is my assumption correct?
I am not aware of the pivot table issue, thus, cannot sat Yes or NO.
This requires to support chart sheets and is a big task. It is part of our GSoC ideas but I have no idea if there will be a student applying for it. It requires us to rework how we handle sheets in calc core.
I am sorry to hear that this requires a major change. I keep fingers crossed that someone applies for this job because it really would be a very nice feature. Especially the part "beside data AND in a separate sheet. (not available in EXCEL thus a unique feature of Calc)"
It has been two years. Any updates on this enhancement?
At least I would appreciate highly if this feature is implemented. It saves a lot of copy & paste and size adjustment work.
One can split this into two tasks. First, add an interface possibility to create / move chart to a separate sheet. It does not necessarily require changing the core since a chart as a separate sheet is available in MS excel import and one can take the existing routine, which will create a worksheet with a chart. This does not require any core change but will solve at least 80% of the problem. Second, if there will be a possibility to have a chart as a separate sheet in a workbook, one will have to update the routine to have everything clean and nice.
Having a new typ of sheets for charts is covered by bug 108913. So let us keep this for the UI option to generate the chart on a new sheet. That would combine the currently three operations "generate chart", "create new sheet" and "move chart to new sheet".
*** Bug 116181 has been marked as a duplicate of this bug. ***
*** Bug 147428 has been marked as a duplicate of this bug. ***