[Issue] Insert Chart On Separate Sheet

Discuss the spreadsheet application

[Issue] Insert Chart On Separate Sheet

Postby TerryWood » Wed Nov 28, 2007 12:33 am

Hi All

I want to insert a chart on a completely separate worksheet instead of putting it on the same sheet as my data. How do I do it please?

Plenty of detail please I'm no expert

Thanks
Last edited by Hagar Delest on Mon Jun 09, 2008 10:44 pm, edited 3 times in total.
Reason: tagged the thread as issue.
TerryWood
 
Posts: 3
Joined: Wed Nov 28, 2007 12:26 am

Re: Insert Chart On Separate Sheet

Postby acknak » Wed Nov 28, 2007 1:26 am

Did you try to cut & paste to the other sheet after you finish creating it?
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Insert Chart On Separate Sheet

Postby TerryWood » Wed Nov 28, 2007 11:10 am

Hi

Yes I can cut and paste but thats not what I want to do. Excel has the ability tio choose current or new sheet. I cannot find this option. Although early help versions of OO Calc talk about this

Regards

Terry
TerryWood
 
Posts: 3
Joined: Wed Nov 28, 2007 12:26 am

Re: Insert Chart On Separate Sheet

Postby mrfrerichs » Fri Feb 22, 2008 5:16 pm

Was there ever a resolution to this issue? My users are wanting to do the same thing.
OOo 3.1 on Ms Windows XP
mrfrerichs
 
Posts: 21
Joined: Wed Dec 12, 2007 6:34 pm

Re: Insert Chart On Separate Sheet

Postby acknak » Fri Feb 22, 2008 5:41 pm

I don't see any way to do it other than cut and paste after the chart is created.

The chart component was completely re-written, first appearing in OOo 2.3.0, and there are still some features of the older implementation that are not complete in the new.

I don't see any issue filed for this, so if it's important to your tasks, I encourage you to file a feature request.

Open Office Quality Assurance - Report Bugs
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Insert Chart On Separate Sheet

Postby Villeroy » Fri Feb 22, 2008 6:15 pm

Excel has a special type of sheet, consisting of a chart only without cells. No, OpenOffice.org does not have such sheets. Place your embedded chart on it's own sheet and set zoom and size accordingly. Next version 2.4 is reported to support individual zoom levels for each sheet.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28644
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Insert Chart On Separate Sheet

Postby acknak » Fri Feb 22, 2008 6:32 pm

OIC--that would be handy indeed. Thanks for explaining.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Insert Chart On Separate Sheet

Postby Dave » Fri Feb 22, 2008 8:37 pm

I am certain I had replied to this. Oh, well ....

The solution already given: You might also consider putting it on its own page [printed page, not sheet.] In order to facilitate that, go to Page Break Preview and drag blue borders around until you get an open page for printing. [You can see/create all pages to be printed in this view.] put the graph image there, and size to fit.

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm

Re: Insert Chart On Separate Sheet

Postby TerryWood » Sat Feb 23, 2008 5:31 pm

Hi All

To Answer the Question "How do you insert a chart on a separate sheet"

DO THIS

Put or all ready have in place on one sheet your data

Go to new sheet

Click on chart wizard button on main menu

Go through wizard until you get to data range part then click on browse icon

Go to sheet where data is and select the data

Complete the wizard details

Voila you have produced a new chart on a separate sheet from the data (as in Excel)

Terry
TerryWood
 
Posts: 3
Joined: Wed Nov 28, 2007 12:26 am

Re: [Solved] Insert Chart On Separate Sheet

Postby Hagar Delest » Thu Apr 17, 2008 5:20 pm

For information: Issue 5736 - Create chart as a sheet (chart only sheet, chartsheet). You should subscribe and vote for it (up to 2 votes per issue).
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28996
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 21 guests