Ask Your Question
0

Can you place a Chart on its own Tab in Calc, as you can in Excel?

asked 2018-08-20 16:54:27 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

In Excel, you can place a chart onto its own Tab, rather than have it on the data spreadsheet. This makes it easier to examine, and to create multiple versions for different purposes. Is this feature available in Calc? If not, do you have any plans to develop it?

edit retag flag offensive close merge delete

4 Answers

Sort by » oldest newest most voted
1

answered 2018-08-21 14:16:17 +0200

Lupp gravatar image

One step simpler than @Liberty Belle told:

Having inserted a chart first into the sheet with the data, Cut and Paste should also work. I would expect this to not depend on the OS. (It may be different concerning very old versions, but it works this way for me with LibO V 4.4.7 and with V 6.1.0.1RC as well.)

You can also insert a new chart without a preselected DataRange into an empty sheet, and select the DataRange in the second step with the mouse from another sheet, or type in its complete range address. You can even use data ranges from different sheets defining the different series.

(How should I know how you did it in Excel? Probably Calc is simply better?)

edit flag offensive delete link more
0

answered 2019-06-30 10:40:57 +0200

Richard214 gravatar image

Works for me in LO version 6. The trick I found was NOT to delete the original on the data sheet. Just move it to some unseen area

edit flag offensive delete link more

Comments

No need to keep original. Charts can be placed on any tab and refer to data on another.

Ratslinger gravatar imageRatslinger ( 2019-06-30 17:51:56 +0200 )edit
0

answered 2018-08-21 00:03:37 +0200

Liberty Belle gravatar image

It would be really helpful if you gave your operating system and version of LibreOffice when asking questions.

On my Mac with LO 6.0.6.2 I don't have the option to choose where to place the chart initially, but I am able to copy and paste it onto a new tab and delete the original chart. The copy does definitely update when I change the underlying data it refers to.

edit flag offensive delete link more
0

answered 2018-08-21 10:19:39 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Thanks for the swift response,Liberty Belle! I'm running Ubuntu 18.04.1 LTS and Gnome 3.28.2. Libre Office 6.1.0.3 I can copy and past a Chart onto a new Tab but not in the way you can in Excel, i.e. not so that the Tab only shows the Chart but it fills the screen, i.e. no spreadsheet template underneath.

edit flag offensive delete link more

Comments

This is not an answer, please use comments.

m.a.riosv gravatar imagem.a.riosv ( 2018-08-21 10:26:49 +0200 )edit

"I can copy and past a Chart onto a new Tab but not in the way you can in Excel, i.e. not so that the Tab only shows the Chart but it fills the screen, i.e. no spreadsheet template underneath." You never said anything in your original post about the chart filling the screen with no spreadsheet template underneath. I answered the question you asked, and frankly am kind of annoyed at your "thanks but that's not quite what I wanted".

Liberty Belle gravatar imageLiberty Belle ( 2018-08-21 17:04:22 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-20 16:54:27 +0200

Seen: 334 times

Last updated: Jun 30