I have a macro in a protected worksheet that performs some calculations and updates a chart when the worksheet is activated by clicking on its tab. Within this macro, I set the minimum value of the chart's X-axis using the following command:
ActiveSheet.ChartObjects("Chart...