Apache OpenOffice (AOO) Bugzilla – Issue 115264
Chart auto-range values are incorrect when a count value is < 5
Last modified: 2013-02-24 21:20:51 UTC
Synopsis: Assume a basic chart, generated from two columns of data. Example., Column A, Fruit-Type, Column B, Fruit-Count. EXAMPLE 1: Column A Column B Apples 5 Oranges 2 Pears 1 Bananas 2 Grapes 4 If we create a basic chart with this data, we see a correct char with the fruit type and count of each type indexed as (1,2,3,4,5) However, in EXAMPLE 2: Column A Column B Apples 1 Oranges 2 Pears 1 Bananas 2 Grapes 4 We see count values of (1,1,2,2,4) or (.5, 1, 1.5, 2, 2.5 ...), depending on the format type of Column B. Either way, the count values are incorrectly ranged. Note - This only occurs when any of the fruit types (column b) are < 5.
There is no bug here. The range is an automatically chosen one. It shows all values. If you do want a specific different range or different intervals you can chose them. Go to Menu->Format->Axis->Y-Axis and select the Scale Tab Page in the upcoming dialog.