Chart "how to"

users
#1

How to move a chart from the data page where it appears to
its own worksheet or tab?

#2

Hi,

Cut/paste.

#3

Hi :slight_smile:

I don't think it is possible to have a chart on it's own as a worksheet in it's
own right. I have been playing around trying the ways other spreadsheet
programs use but can't see how to do this. I managed to get the chart onto a
different worksheet using copy&paste but then had to redefine the data sources!
Have you managed this or found any good answers?
Regards from
Tom :slight_smile:

#4

Hi,

Hi :slight_smile:

I don't think it is possible to have a chart on it's own as a worksheet in it's
own right. I have been playing around trying the ways other spreadsheet
programs use but can't see how to do this. I managed to get the chart onto a
different worksheet using copy&paste but then had to redefine the data sources!
Have you managed this or found any good answers?
Regards from
Tom :slight_smile:

________________________________
From: Gérard FARGEOT <gerard.fargeot@orange.fr>
To: users@libreoffice.org
Sent: Mon, 25 April, 2011 16:32:07
Subject: re: [libreoffice-users] Chart "how to"

Hi,

Cut/paste.

> Message du 25/04/11 17:13
> De : "CohoMike"
> A : users@libreoffice.org
> Copie à :
> Objet : [libreoffice-users] Chart "how to"
>
> How to move a chart from the data page where it appears to
> its own worksheet or tab?
>
--
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Older versions of Excel could put a chart on separate sheet as an
option. I have tested this in the latest version of Excel but I believe
it is still true.

I believe Softmaker's spreadsheet could do this, I this was years ago
though.

#5

Tom, I have not found a way. I'm used to the Excel 2003 dialogue that
allows for a chart
to be on a separate worksheet with its own tab, where it looks like a
slide in the PowerPoint. Copy & paste
in LibreOffice doesn't really do what I want to do. You can't have
everything!

mike parks
www.michaeljparks.com

#6

Jay, right, doesn't look like LibreOffice lets one do what one can do in
Excel 2003,
put the chart on its own worksheet. CohoMikemjp@michaeljparks.com

#7

CohoMike, actually if you do that in Excel and open the file in Calc, the
Chart tab will show up as a regular spreadsheet tab with a large chart on
top of the cells :slight_smile:

#8

Hi :slight_smile:
It's the 1st difference i have noticed where the lack of it in LO is not
advantageous. I'm not certain that it's a disadvantage but it's something i
used to do quite often back in MSO. I wonder what would happen to such a chart
created in MSO and then opened in LO. Presumably a chart can be copy&pasted
into Impress just the same.

As you say, we can't have everything.
Thanks, good luck and regards from
Tom :slight_smile:

#9

Tom Davies wrote (27-04-11 19:15)

I don't think it is possible to have a chart on it's own as a worksheet in it's
own right.

I don't understand the issue at all.

I can create a chart.
(de-select it, select it)
and cut and paste it to any sheet in the document. Reference to the data range is just preserved.

Ciao - Cor

#10

If you used Excel you would know what CohoMike is talking about.

Excel allows to create a special type of Sheet named Chart where the only
object is a Chart using data from one of the other Sheets. It is
particularly useful when you have large spreadsheets with many tabs. It
makes it easy to locate a chart and it is very easy to switch to/from this
mode and to create Chart tabs.

#11

I can do the same as Cor, copy-paste, cut-paste.
steve

#12

Right. I prefer to have the chart on its own sheet, away from the data,
where I can see clearly what it will look like in the presentation software.