Thread: Secondary Axis Chart

I am trying to understand how secondary axis's work. And I have the concept down and have created a secondary axis.

(See attachment) My data points are all junk and I just put them there to get something on the chart.

My goal: I want the secondary X axis to not be as tall as the primary.

So if the primary has 1-10. I want the secondary to only be labeled to the 0-1. I want the secondary axis to be shorter than the primary. Seems like no matter what I do, it auto formats to expand to the top. I want there to be a bunch of space between the max secondary x axis max and the top of the chart. So the primary X will go from floor to roof of the chart, and the secondary will go from floor to 1 unit, and far from the roof.

Originally Posted by Andy Pope

The min/max scale values always go from bottom to top of plot area.

If you only want it to reach part way up then you will need to set the maximum scale value to something larger.
You can use a custom number format to mask the values displayed.

Close, Your suggestion got me one step closer, but I'm curious how you do a complex format like that in the "Number Format" section.

The options are only <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>

in my case, i'd want an option to add IF(#>1), "". So display blank if greater than a number I set. This would allow me to set the limit at which my secondary X axis would display.

Solved by you Thanks!