Carl,

Please try one of these:

Sub RefreshChart1()
ActiveSheet.ChartObjects("Chart 70").Activate
ActiveChart.Refresh
End Sub

or

Sub RefreshChart2()
Dim Cht As Chart
Set Cht = ActiveChart
Cht.Refresh
End Sub

----
Regards,
John Mansfield
http://www.pdbook.com


"Carl Bowman" wrote:

I am trying to refresh a chart in an Excel 2000 worksheet without
recalculating the whole worksheet. Tried using the following syntax to no
avail (this is not a pivot chart):

ActiveSheet.ChartObjects("Chart 70").Select
ActiveChart.Refresh

Thanks,
Carl