Change chart parameters without immediately updating the chart

[IN_77]

Hello,

I am currently using a VB application with Microsoft Excel 2007 that was previously used on the Excel 2003 version to generate a large number of charts based on a user-specified file. I have found that the 2007 version is considerably slower at generating these charts because it is slow at updating every parameter in the chart (using VB code).

I have been curious if there is a way to change the parameters of a chart before drawing it to a sheet or without updating it immediately after every change.

For example:

With ActiveChart.Axes(xlValue)
        .MinimumScale = 16
        .MaximumScale = 26
        .MinorUnitIsAuto = True
        .MajorUnitIsAuto = True
        .Crosses = xlCustom
        .CrossesAt = 3
        .MajorGridlines.Border.ColorIndex = 48
End With

Could the generated chart be updated only after the entire With statement somehow? Or use a template Chart object to generate the entire graph at once (I've looked into Chart Wizard but it appears to be limited in functionality and may not even work properly in 2007).

Thank you for your assistance, please let me know if you would like to clarify my situation further.

[Andy Pope]

Do you turn screen updating off at all?

Charts are slower to render in xl2007 if you have lots of data, this is due to the increased formats that can be applied to all the chart elements.

For further assistance a sample workbook would help.

[IN_77]

Thank you!

That command does exactly what I looking for, can't believe I didn't find it sooner.

Referring to:

Application.ScreenUpdating = False

and

Application.ScreenUpdating = True