How would I change a chart's scale with VBA? Right now I have the following:
and would like to do this without excel physically selecting the chart (first line of code, but have it simply change the value of max and min.ActiveSheet.ChartObjects("Chart 7").Activate ActiveChart.Axes(xlValue).MinimumScale = price_chart_min ActiveChart.Axes(xlValue).MaximumScale = price_chart_max
Thank you.
Bookmarks