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
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
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.1.4, Ubuntu 16.04
Posts: 2899
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.1.2 on Xubuntu 16.04, (Xenial Xerus) and PortableApps port 4.1.2 on Windows 7
User avatar
Hagar Delest
Posts: 26660
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 14.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Posts: 22089
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: Zizi64 and 31 guests