Apache OpenOffice (AOO) Bugzilla – Issue 13571
Selecting and changing the data range to be plotted
Last modified: 2013-02-24 21:19: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?
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.
closed
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.
I take it.
See: http://graphics.openoffice.org/chart/featurewishes.html So i close it again.