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.
Bookmarks