Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Mary -
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 You can select just one series at a time. 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. If I were doing it for myself, I'd write a little macro. First, the code lets you set something up to run without much of your attention, so you wouldn't care if it kept updating slowly. Second, you can suspend screen updating while the macro runs. There's no way manually to achieve this effect. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing Charts in Excel 2003 | Charts and Charting in Excel | |||
Excel 2003 Using graphics in charts | Charts and Charting in Excel | |||
Modifying Default Colors in Excel 2003 | Setting up and Configuration of Excel | |||
Excel 2003 Charts | Charts and Charting in Excel | |||
The x-axis title is truncated in EXCEL charts 2003. | Charts and Charting in Excel |