View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
maryj maryj is offline
external usenet poster
 
Posts: 76
Default Modifying charts in Excel 2003

2 questions -

1. With a chart that has already been created, in the Source Data dialog
box, is there a way to select multiple series at one time to remove? I've
tried the shift and control keys with no luck - just wondering if I missed
anything.

2. Some of the charts have a lot of data so when a series is deleted it
takes awhile for the chart to recreate without that series. Is there a way to
turn off the refresh of the charts until I want it to refresh? I tried
changing the Calculation to manual but that does not seem to impact charts.

Thank you!
--
maryj