Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 05-08-2006, 11:00 AM   #1
LQ Newbie
Registered: Oct 2005
Posts: 18

Rep: Reputation: 0
editing series in openoffice calc...


I need to find out how to edit the name of serveral series within a chart in OO 2.0 without adding entirely new rows to pull the names off of.

I've done this in Excel before, but can't seem to get an edit widow in openoffice.

any ideas?

Old 05-08-2006, 03:16 PM   #2
LQ Newbie
Registered: Oct 2005
Posts: 18

Original Poster
Rep: Reputation: 0
Well, I kind of found a work around... Not to my satisfaction, but it got me through today.

(From memory...)

1. save completed document to another format (I did excel)
2. open that .xls file
3. "Select all" on the chart page you want
4. Paste into a new blank page on your original file
5. Double click the chart
6. Right-click on the white-space of the chart
7. select "Chart Data"
8. enter the information required.

I had issues with the office format holding the information and reproducing the charts after a save and quit. I noticed that if I saved the finished files as an opendoc rather than .xls everything saved as needed.

Hopefully someone knows a better way to do this?

Thanks again.
Old 05-08-2006, 03:21 PM   #3
Registered: Apr 2005
Location: Rochester, MN
Distribution: Ubuntu 7.04
Posts: 127

Rep: Reputation: 15
You could try the openoffice forums too I guess.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
OpenOffice Calc Chart R00ts Linux - Software 11 10-16-2007 06:10 AM
Openoffice calc dajomu Linux - Software 1 10-27-2005 05:56 PM
openoffice calc question buffed317 Linux - General 1 09-11-2004 03:27 PM
openoffice calc question... marsques Linux - Software 2 07-10-2004 04:30 PM
Making charts in OpenOffice Calc leontini Linux - Newbie 2 11-25-2003 09:42 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:01 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration