Edit chart data - extend the data range

Discuss the spreadsheet application
Post Reply
gennaro
Posts: 1
Joined: Mon Jul 07, 2008 5:58 pm
Location: Impruneta (Firenze) Italia

Edit chart data - extend the data range

Post by gennaro »

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
jrkrideau
Volunteer
Posts: 3816
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: edit chart data - extend the data range

Post by jrkrideau »

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.
LibreOffice 7.3.7. 2; Ubuntu 22.04
User avatar
Hagar Delest
Moderator
Posts: 32649
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Edit chart data - extend the data range

Post by Hagar Delest »

Have you tried the official version? [Ubuntu] Installing OOo on Debian and Co.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Edit chart data - extend the data range

Post by Villeroy »

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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply