View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Karine Karine is offline
external usenet poster
 
Posts: 20
Default SCROLL BAR FOR A 52 WEEK CHART

Hi there,

I have many charts that are updated on a weekely bases (52 weeks) however
currently I am going in manually and changing the cell rangers to update my
graphs because I only need 10 weeks at a time showing, but I'd like the
option to check the previouse weeks if need be. I know there is a way to add
a scroll bar to the charts and drag that along to update the charts. I can't
seem to figure it out the macro to run. I am using the Scroll Bar from the
Forms toll bar.
Any help would be great.

Thanks,
Karine