https://bugs.documentfoundation.org/show_bug.cgi?id=159550
Bug ID: 159550
Summary: Automatic low-high right y-axis range is sometimes
zero-based even with negative values (stockchart3)
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 192380
--> https://bugs.documentfoundation.org/attachment.cgi?id=192380&action=edit
stockchart3-right-axis-range-bug-data.ods produces range 0.0 - 16.0
Amount and low-high range chart (stockchart3) sometimes produces an automatic
low-high y-axis range on the right that starts from zero even though some
values are negative.
If there are negative values, the automatic range lowest value is zero and the
chart does not show the negative values.
Steps to reproduce:
1. open stockchart3-right-axis-range-bug-data.ods
2. select $A$1:$D$15
3. menu: Insert / Chart ...
4. Chart type: Stock / Stock Chart 3
5. button: Finish
Actual Result:
Right scale is 0 to 16 even though temperature data range is -15 to 5.
Expected result:
Right axis range is -15 to 5, or -16 to 6, or -20 to 10.
6. Right click on right axis, select "Format Axis ..."
7. In "Secondary Y Axis" dialog, select "Scale" tab.
Actual result:
Must scan data to find minimum and maximum values, and manually set scale
minimum and maximum values.
Expected result:
Ability to Choose value type and range will be automatically recalculated.
Low-High range value type
(*) 'Ratio' (compares amounts of zero or more, may use log scale)
( ) 'Interval' (compares positions, may not use log scale)
Request ability to change the range type to 'interval' values, such as
temperatures.
(A column of 'ratio' values represents a nonnegative amount, such as a length
or volume. The ratio between these amounts can be visualized in pie chart or
stacked bar chart. A column of 'interval' values represents a position that
may be negative, zero, or positive, such as temperature or latitude. These
positions can be compared on a line or scatter chart.)
(Terminology of value types including 'Ratio' and 'Interval'
https://www.geeksforgeeks.org/data-mining-data-attributes-and-quality/ )
--
You are receiving this mail because:
You are the assignee for the bug.
