Hello all,
I'm looking for a way to auto adjust the primary and secondary y-axis bounds in my line chart. When excel auto adjust the bounds it always selects 0 as the lower bound, which effectively makes the chart useless since all of the "action" is happening in the millions; To complicate things a bit further, I have a slicer that allows users to drill down to a more specific data point which means that both y-axes need to be dynamic.
I've used a vba to auto adjust the axis value with only one y-axis and all I'm finding online are solutions on how to set the same max/min values for the primary and secondary y-axis, but I am looking for a solution that will allow different dynamic max/min ranges for both y-axes
Thanks in advance
Bookmarks