Issue 86103

Summary:

Order of range data

Product:

General

Reporter:

rusivi <rusivi1>

Component:

chart

Assignee:

niklas.nebel

Status:

CLOSED IRREPRODUCIBLE

QA Contact:

Severity:

Trivial

Priority:

CC:

elish, IngridvdM, issues, villeroy

Version:

3.3.0 or older (OOo)

Keywords:

needmoreinfo

Target Milestone:

---

Hardware:

OS:

Windows Vista

Issue Type:

ENHANCEMENT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
Chart Wizard Screen Shot	none

Description rusivi 2008-02-14 14:56:03 UTC

In Calc, plotting column data via Graph Wizard Line Chart: 

Graph Wizard>Chart Type>Data Range

Calc plots column data from column top to bottom (left to right of the graph)
($Sheet1.$I$2:$I$4018), irrelevant to user specified inputs
($Sheet1.$I$4018:$I$2) indicating column bottom to top plotting (left to right
of the graph).

Comment 1 rusivi 2008-02-14 15:13:38 UTC

Created attachment 51513 [details]
Chart Wizard Screen Shot

Comment 2 kla 2008-02-25 11:18:32 UTC

@IHA: pls have a look if its possible to change the plots.

Comment 3 IngridvdM 2008-02-28 13:24:00 UTC

This is the way all ranges in calc are handled. It is not a decision of the
chart in which order the values are given for a certain range strings.
->Niklas, is there something planned for the behavior of ranges in calc thus
A1:B2 is not equal B2:A1 ?

Comment 4 Edwin Sharp 2014-02-28 11:40:58 UTC

Please attach spreadsheet.

Comment 5 Edwin Sharp 2014-03-12 12:41:37 UTC

No info from author.

Comment 6 Andreas Säger 2014-03-14 17:55:12 UTC

Like most users who have some problem with a line chart, the reporter wants an x/y-scatter chart which has a _numeric_ x-scale where the x values appear according to their numeric value rather than their position on the sheet.