Created attachment 74792 [details]
image of chart wizard with indication where the location choice could be shown
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.
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
Operating System: Windows XP
Version: 18.104.22.168 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.
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. ***