Set Chart X Max Value Based on Cell Value

[fergusga1815]

As per the attached sheet, I am looking to:

- Have the x-axis of the chart on the 'Prioritisation' sheet so that the min is always zero and the max is taken from cell BG1 in the 'Master Copy' worksheet. This value will change as the slicers are used to update the chart so the axis will need to be recalculated each time the chart updates

- The y axis min should always be zero and the max 100

Is there any way to automate the above? I have tried several solutions with no success.

[MrShorty]

You say that you have tried several solutions with no success, but you don't tell us what you have tried, so we might end up repeating some strategies that you have already tried. Risking that, have your tried this solution: https://peltiertech.com/chart-udf-control-axis-scale/

[fergusga1815]

Yes I have tried this along with https://exceloffthegrid.com/chart-axis-min-mix/ and https://www.extendoffice.com/documen...h-formula.html with no success. This may be user error but regardless I just can't get this too work...

[Andy Pope]

I put this in Prioritisation!A1 and it worked

A1: =setChartAxis("Prioritisation", "Chart 1", "Max", "X", "Primary", 'Master Copy'!BG1)

[fergusga1815]

Thank you so much, that works perfectly!