Hello,
My challenge is that I have a stacked column chart, with an average trend line on the secondary axis. The chart is dynamic and controlled via slicers. Whenever a different slicer option is selected, the chart changes and updates with the corresponding data. This means that the scale for both axis changes independently based on the underlying data. However, I need the secondary axis to match the primary. For example, item #1 has a max value of 10 on the primary axis, and 5 on the secondary axis, while item #2 has a max value of 50 on the primary and 15 on the secondary. For item #1 I'd like both axis to show 10 and for item #2 for both to show 50. Simply changing the max value for the secondary axis does not work since when a different slicer selection is made, the axis won't change.

I'm at a loss here so any help would be greatly appreciated. Thanks in advance.