The plot range in an excel chart is getting smaller? Why? C

[Kristian Fern]

I have a macro that changes a data table and associated graphs. To make the graphs user friendly I update axis Min/Max by tying both to a cell value which is Min/Max values of the table +/- a constent (say 500). This is accomplished with a embeded worksheet macro that updates when any calculation is required (automatically when a cell value changes). When I run the macro the resulting plot area is gets increasaingl smaller each time the graph is updated (just a little each period). After 100 or so of these updates the chart is unreadable? Can I lock the plot range relative to the charts borders so the only thing that changes is the axis values??

[zacemmel]

Try setting the plot area of the chart to a desired width/height within the macro.

That would be:

Activesheet.Chartobjects("chartname").plotarea.width = 300
Activesheet.Chartobjects("chartname").plotarea.height = 200