Secondary axis are used especially if data ranges differ for different data (-rows / -colums) The ranges for that data might differ THAT MUCH: example data row 1 has a scale to 1 000 000 data row 2 has a scale to 1 Data of row 2 might implode to the x-axis AND would not be seen in a Diagram ! NOR would they be accessible by clicking on it. THIS makes it difficult to scale them to a secondary axis (if addet to the diagram) As workarround the primary axis can be scaled to the LOWER range to get data of row 2 accessible and connect and scale them to the secondary axis with the nessecarity to rescale the primary axis to the origin. REQUEST: A much easier handling was, if -after adding a secondary axis- the formatting Dialog for these axis had the possibility to select THAT data that should scaled within these axis hope my english is sufficient regards karl
Sounds vaguely useful, so I'll set to NEW :) Maybe you could include a picture of the desired result (and perhaps a problematic result with the current situation).
Created attachment 119161 [details] CALC Testcase with manual includet
After Step2 select item "Data Series 'Datarow2'" from the drop-down-list in the chart Formatting toolbar. Then click on icon "Format Selection" at the right side of the drop-down-list. You get the properties dialog. Tab "Options" has the settings you need.
Thanks, Regina. I guess we can close this.
Hi Thanx especially Regina. I figured out, that i can access the "Legend" (Datarow 1 // Datarow 2) where i can Click on the Symbol to access the Data to connect them to secondary Axis. To Regina: I am german and do not undersand for shure your decription: "After Step2 select item "Data Series 'Datarow2'" from the drop-down-list in the chart Formatting toolbar. Then click on icon "Format Selection" at the right side of the drop-down-list. You get the properties dialog. Tab "Options" has the settings you need." If possible describe it in german too, so that -if it is a different way- i can figure it out too. thanx, regards to all karl