Apache OpenOffice (AOO) Bugzilla – Issue 30526
chart types act differently for the same data
Last modified: 2013-02-24 21:20:48 UTC
I created sample table. First I created chart typrectangular. As You can see, it takes the data values as the same group of data. (picture 1) Then I changed the char type to cake. What happens? Now it distinguishes the data and gives them different colours and different legend titles (pic 2). I change to other type of rectangular chart -colors are gone and legend shows just one type of data (pic 3). Let's see, how it applyes to created chart. I set the chart to display values, and to display them as percentage. For cake, it shows different data with different colours and the correct percentage (pic 4). But I change the chart type to cake -and colours are gone again, and the percentage shows for all data the same value: 100%! (pic5) I deleted the legend, but logically, it was the same (one colour one row). I needed to represent some data in rectangular chart and instead of correct values and different colours, it shows one colour, 100%. But while I wanted to make more snapshots, I opened the file again and wow! The rectangular chart now represent colour too! Why it didn't before? (pic 6) For the last subtype of rectangular chart, it even shows all 100% values graphically too -with identical length too! But since this was after opening the file (before taking snap 6), it's still with mixed colours! (pic 7)
Created attachment 16053 [details] Sample file
Created attachment 16054 [details] pic 1
Created attachment 16055 [details] pic 2
Created attachment 16056 [details] pic 3
Created attachment 16057 [details] pic 4
Created attachment 16058 [details] pic 5
Created attachment 16059 [details] pic 6
Created attachment 16060 [details] pic 7
First item (same color/different color) is definitely not a bug. Those columns or bar charts use different colours to distinguish different Values for the same "item". In this case if you had more than one value for "one", "two" and "three", these would be distinguished. If you want to distinguish the rows, you have to toggle the "( ) data in columns (o) data in rows". The second problem (100%) is intentional as well. This is not the percentage of the individual value, but of the data set. It shows 100% because you only have one value per item, so this is always 100%. I'm marking this as a duplicate. Please file seperate issues for any remaining problems. But please remember to only file *one single problem per issue*. If issues are related you can refer to them (see issue #) but please focus on one problem. Otherwise it has to be closed. *** This issue has been marked as a duplicate of 23170 ***
Created attachment 16971 [details] percentage is related to the overall value per "item", color distinguishes datasets
closing issue.
Created attachment 73015