Bug 60822 - Support chart sheets in calc
Summary: Support chart sheets in calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA
: 116181 147428 (view as bug list)
Depends on:
Blocks: Chart-Wizard
  Show dependency treegraph
Reported: 2013-02-14 00:48 UTC by bugquestcontri
Modified: 2024-05-22 08:34 UTC (History)
14 users (show)

See Also:
Crash report or crash signature:

image of chart wizard with indication where the location choice could be shown (38.84 KB, image/jpeg)
2013-02-14 00:48 UTC, bugquestcontri

Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2013-02-14 00:48:15 UTC
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. 

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: release
Comment 1 Rainer Bielefeld Retired 2013-02-14 07:06:58 UTC
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?
Comment 2 bugquestcontri 2013-02-17 11:59:06 UTC
I am not aware of the pivot table issue, thus, cannot sat Yes or NO.
Comment 3 Markus Mohrhard 2013-03-12 23:21:26 UTC
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.
Comment 4 bugquestcontri 2013-03-24 11:22:45 UTC
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)"
Comment 5 Joe Nahmias 2015-04-07 17:26:56 UTC
It has been two years.  Any updates on this enhancement?
Comment 6 bugquestcontri 2015-04-21 10:58:47 UTC
At least I would appreciate highly if this feature is implemented. It saves a lot of copy & paste and size adjustment work.
Comment 7 adams13soft 2015-08-22 22:23:13 UTC
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.
Comment 8 Regina Henschel 2018-03-04 15:50:44 UTC
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".
Comment 9 Regina Henschel 2018-03-04 15:53:50 UTC
*** Bug 116181 has been marked as a duplicate of this bug. ***
Comment 10 m_a_riosv 2022-02-15 16:06:51 UTC
*** Bug 147428 has been marked as a duplicate of this bug. ***