Ask Your Question

How can I put a chart on a separate sheet in Calc? [closed]

asked 2013-02-10 03:02:44 +0200

JKEngineer gravatar image

updated 2020-07-21 19:27:15 +0200

Alex Kemp gravatar image

I know that the help file specifically states that charts cannot be on their own sheet. This is by far my most common use of charts in Excel. It allows charts to always be out of the way of the data and formulas on the worksheet, for example as the data and calcs grow, I don't have to worry about the chart being in the way. In addition, it is a good way to be able to export, print, or share just the chart.

Is this something that could be implemented in LibreOffice?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 18:15:07.859755


Hi @JKEngineer,

qubit hits you with his karma stick

That should give you enough karma so you can comment on posts :-)

qubit gravatar imagequbit ( 2013-02-10 04:02:00 +0200 )edit

6 Answers

Sort by » oldest newest most voted

answered 2013-02-10 04:07:22 +0200

qubit gravatar image

@JKEngineer -- I think it's possible that the help file is mistaken or outdated. I believe you can put a chart on a separate sheet:

Please let me know if that works for you. If you're successful, I'll pass a message along to the appropriate folks to have them update the help file.


edit flag offensive delete link more

answered 2013-02-12 04:39:55 +0200

ROSt52 gravatar image

This discussion gave me in idea for an enhancement with which Calc would be superior to EXCEL

Copy & Paste a chart to a separate sheet is a possibility but a bit cumbersome. On the other side having a typically smaller version beside the data can be very convenient if one wants/needs to modify some data and the graphical result is to be seen immediately.

Therefore the enhancement request would be a selection of 3 choices in the chart wizard. - place chart on the same sheet as data - place chart on a separate sheet - place chart on the same sheet as data and on a separate sheet

Would you regards this a reasonable enhancement request?

edit flag offensive delete link more



+1. I suggest that the selection mechanism have little icons or sketches to help the user visualize the difference between the options.

What should the default behavior be? Same sheet as data?

qubit gravatar imagequbit ( 2013-02-12 06:07:24 +0200 )edit

answered 2013-02-10 16:30:18 +0200

JKEngineer gravatar image

updated 2013-02-10 16:32:51 +0200

I feel all karmalized! thanks.

I tried the copy and paste to a new sheet and it works. The primary difference from Excel's behavior seems to be that the chart creation dialogue does not provide for "put on separate sheet".

The pasted copy on the separate sheet is linked back to the values on the source sheet. I found that it initially acts like a graphic, but the chart commands (chart type, axis, legend, data range, etc.) can be accessed by first double-clicking the graphic and then right clicking.

It also allows more than one chart to be put on the target sheet / chart sheet.

Pretty neat!

(LO Portable, on Win XP Pro SP3)

edit flag offensive delete link more


@JKEngineer -- Good that this worked out for you. We've had a number of requests for the same "put on separate sheet" feature. Could you please file an enhancement bug and describe how this works in Excel? You can link to the bug from here as "fdo#12345"

qubit gravatar imagequbit ( 2013-02-12 02:17:05 +0200 )edit

answered 2013-02-13 10:47:00 +0200

ROSt52 gravatar image

@qubit: Are you going to forward this enhancement request?

edit flag offensive delete link more


@ROSt52 -- I'm a bit swamped with LO tasks now, but it would be great if you could file the enhancement. Please post the bug# as a comment on @JKEngineer's Answer above (or your's -- you expanded on the idea!), so it's easier to see that one has been filed.


qubit gravatar imagequbit ( 2013-02-13 20:21:22 +0200 )edit

answered 2013-02-14 01:51:46 +0200

ROSt52 gravatar image

Enhancement request is forwarded.

I hope we will get this feature soon.

@qubit I did not know that "@name" triggers an email ping.

edit flag offensive delete link more


@ROSt52, Take a look at your User profile -> subscriptions -> "Comments and posts mentioning me".

That config option will send you email whenever someone uses your @name in a post. Hopefully it's on by default!

qubit gravatar imagequbit ( 2013-02-14 22:06:06 +0200 )edit

@qubit Thanks for that hint. It was at least switched on together with other options. Now I know and optimize my settings.

ROSt52 gravatar imageROSt52 ( 2013-02-15 02:15:02 +0200 )edit

answered 2013-02-12 09:58:11 +0200

ROSt52 gravatar image

@qubir: Thanks for taking up the idea.

When I look at the chart wizard

image description

I suggest to add "5. Location". Default on the data page might be the best.

I am not sure if I understand your ideas about icons. Do you think about icons in a toolbar? If so, it would be nice if the icons can be clicked on while on the data page and Calc would automaticially do the rest, and stop for name of the new sheet with the default name: "Chart x" or something similar.

edit flag offensive delete link more


@ qubit: Sorry for the typo in your name in my answer!

ROSt52 gravatar imageROSt52 ( 2013-02-12 10:00:28 +0200 )edit

@ROSt52 -- no worries :-)

Two notes:

  1. feel free to edit your Answer instead of posting a follow-up comment
  2. I didn't get an email ping from your comment because there's a space between "@" and "qubit"
qubit gravatar imagequbit ( 2013-02-13 20:18:28 +0200 )edit

Question Tools


Asked: 2013-02-10 03:02:44 +0200

Seen: 19,925 times

Last updated: Feb 14 '13