Hi
There is something strange with a spreadsheet, which contain many charts (all represent different temperature sensors).
I've made a macro to change at once time the X-Axis range (=time axis) on all charts.
The 1st time it works without any problem but if I want to change a second time the range, then many charts will be also reduced (only the chart inside the chart frame is reduced), although the macro act only on the values of the axis (... .Axes(xlCategory).MinimumScale = ...)
Have anyone any ideas why this happen. Is there any possibility to lock the size of my chart in order that when I change something in the axis it changes only what I want?
Emmanuel
There is something strange with a spreadsheet, which contain many charts (all represent different temperature sensors).
I've made a macro to change at once time the X-Axis range (=time axis) on all charts.
The 1st time it works without any problem but if I want to change a second time the range, then many charts will be also reduced (only the chart inside the chart frame is reduced), although the macro act only on the values of the axis (... .Axes(xlCategory).MinimumScale = ...)
Have anyone any ideas why this happen. Is there any possibility to lock the size of my chart in order that when I change something in the axis it changes only what I want?
Emmanuel