Apache OpenOffice (AOO) Bugzilla – Issue 21654
Chart can't handle data sets in different orientation
Last modified: 2013-02-24 21:22:31 UTC
If I have a matrix and I want to chart a row and a column, I can not. If Chart has more than one data set, all data must be either (adjacent) rows or (adjacent) columns. In scientific, engineering and business applications it is often a requirement that a chart contains data collected in different directions. It can not be done in OOo, but it is not a problem in for example Excel or ApplixWare. I attach an Excel'97 example spreadsheet with 2 data sets, a column and a row. The chart on the sheet should show 2 data sets, and in Excel it indeed does. After importing to OOo, however, the chart has 5 data sets, one with many values, all others with a single one, which is obviously incorrect.
Created attachment 10602 [details] Column and row data set Excel example
duplicate *** This issue has been marked as a duplicate of 3997 ***
Closed as duplicate