Apache OpenOffice (AOO) Bugzilla – Issue 100656
Secondary Y Axis does not have Major Y Axis Values on first definition
Last modified: 2013-02-24 21:21:07 UTC
When a wide chart covering lots of data is created a Secondary Axis is often needed to show the Major axis on the right to reference the data close to that position. Unfortunatly when you create it (and this needs to be done daily because the values aren't saved (see bug #100655) the Secondary Y Axis has no relationship to the values of the Major Y Axis, and these have to be redefined manually by double clicking on the right Y axis. This occurs with line graph charts of various types. I don't know if it occurs for all charts. This is a major annoyance because it has to be done daily so that the chart can be screen printed and posted elsewhere. Recreation: 1.Create a Line graph chart with a long column of data (I'm at over 150 rows currently). 2.Select the Chart and Define the Major Axis, give it Ninimum=0, Maximum=500, Major Interval=100. 3.Select the chart, Select Insert -> Axes, and under Secondary Axes, check Y axis. The Y axis appears with data that does not coordinate with the Major Axis. 4. Compare the default values inserted on the Secondary Y axis with those on the Major Axis. They default to Minimum=0, Maximum=12, Major Interval=2, which does not coordinate in any way with the Major Y Axis. This should coordinate and get its default values from the Major Y Axis.
This problem was already reported with issue 80518 and will be fixed in OOo 3.1. Thanks for your report! *** This issue has been marked as a duplicate of 80518 ***
closing as duplicate