Assign a formula for Axis Option for x-axis

[mikeannetta]

I have a Combo Chart called "SUMMARYCHART". Excel 2019 Standalone version on my computer.
I have a Formula for: MAX and Min values in cells noted below.

• MAX x-axis in cell I68
• MIN x-axis in cell I69
• Tick Marks in cell I70

The ticks value is left at 0

I use a lot of Pivot table data that is linked to SLICES, so whenever I change the SLICE of Data used, the chart x axis with automatically update to the new values. How can I do this?

Thanks!
Mike