Issue 13571

Summary: Selecting and changing the data range to be plotted
Product: General Reporter: Unknown <non-migrated>
Component: chartAssignee: kla <thomas.klarhoefer>
Status: CLOSED NOT_AN_OOO_ISSUE QA Contact: issues@graphics <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: 3.3.0 or older (OOo)   
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: TASK Latest Confirmation in: ---
Developer Difficulty: ---

Description Unknown 2003-04-17 23:52:45 UTC
Hi!

With OOo Chart it's very hard to plot more than one data curve into one 
X-Y-chart.
This is, because one can't select which of the colums or rows contain the
X-values and which contain the multiple Y-values. 
One can only select one big region and OOo tries to determine where to find the
X- and the Y-values. But it often fails. 
And, one can't change these regions in an existing diagram with has multiple curves.

Why isn't there a possibility to let the user manually select the cells (rows or
colums) to use as X- and Y-values?
Comment 1 kla 2003-04-23 14:35:56 UTC
Please only one Task per issue.
And all the tasks sounds like support request.
As an exception one Tip: 
Multiselection (not only one big region) is possible if you enter in
the first Page of the Autoformat Chart Dialog Field Range
$Sheet1.$A$1:$B$2;$Sheet1.$C$3:$D$4 for Cells A1 to B2 and C3 to D4 or
you select the Range with pressed Ctrl-Key.
For further information please use only the
Mailinglists.
Comment 2 kla 2003-04-23 14:36:19 UTC
closed
Comment 3 Unknown 2003-04-23 15:15:58 UTC
This is not the actual problem!

The Problem is, that you can't say OpenOffice which part of the
selected data range to use as X- or as Y-values. 

OpenOffice tries to determine this automatically but often fails. 

So, my suggestion would be to add a selection item in Autoformat Chart
Dialog where one can select this manually.
Comment 4 kla 2003-04-24 07:32:43 UTC
I take it.
Comment 5 kla 2003-04-24 07:34:12 UTC
See: http://graphics.openoffice.org/chart/featurewishes.html
So i close it again.
Comment 6 kla 2003-04-24 07:34:27 UTC
closed