Edit chart data - extend the data range

Discuss the spreadsheet application

Edit chart data - extend the data range

Postby gennaro » Mon Jul 07, 2008 6:14 pm

Hi, I am using linux kubuntu feisty 7,06 with openoffice calc 2.2.0.

I have created a chart, I would like to extend the data range.
I should able to extend the data range in 2 ways; heither doubleclicking on the chart (the data range is showed in a blue box) and dragging the range or clicking on the edit menu in main toolbar and select chart data.

Unfortunatelly both methods do not work for me :(
The range gets highlighted but I can not drag the range
and the edit chart data in the edit manu is not active (grey).

Any idea, many thanks
Gennaro
Last edited by gennaro on Tue Jul 08, 2008 5:01 pm, edited 1 time in total.
OOo 2.2.X on Ubuntu 7.x + linux kubuntu feisty 7,06
gennaro
 
Posts: 1
Joined: Mon Jul 07, 2008 5:58 pm
Location: Impruneta (Firenze) Italia

Re: edit chart data - extend the data range

Postby jrkrideau » Tue Jul 08, 2008 3:20 pm

I don't have any problem with your second method using 2.3.1 under XP. We have heard any number of reports of problems with Ubuntu versions of OOo. If you're using the kubuntu version of OOo you might want to consider updating to 2.3 or 2.4 from the official OOo site.
AOO 4.0.1, Ubuntu 13.04
jrkrideau
 
Posts: 1913
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Edit chart data - extend the data range

Postby Hagar Delest » Mon Jul 28, 2008 5:33 pm

Have you tried the official version? [Ubuntu] Installing OOo on Debian and Co.
AOO 4.0.1 on Windows 7 and Xubuntu 14.04 (Trusty Tahr)
User avatar
Hagar Delest
Moderator
 
Posts: 25106
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Edit chart data - extend the data range

Postby Villeroy » Mon Jul 28, 2008 6:04 pm

A third way to extend your data:
3a Insert a row/column for each newly entered record.
3b Insert new rows/columns for all records to be pasted.
This will extend formula references as well, such as =SUM($A$1:$A:9) --> =SUM($A$1:$A:9)

[Calc, Python] expand/shrink list ranges
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17311
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Jezzabythesea and 21 guests