View Single Post
  #1   Report Post  
Carl Bowman
 
Posts: n/a
Default How To Refresh Chart Data Without Calculating The Worksheet

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