LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Modifying charts in Excel 2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Charts in Excel 2003 Marilyn Charts and Charting in Excel 1 January 30th 07 05:16 PM
Excel 2003 Using graphics in charts Trish Charts and Charting in Excel 1 September 27th 06 03:32 AM
Modifying Default Colors in Excel 2003 Reader Setting up and Configuration of Excel 1 May 20th 05 03:47 PM
Excel 2003 Charts KnightSurfer Charts and Charting in Excel 0 April 20th 05 02:03 AM
The x-axis title is truncated in EXCEL charts 2003. Bernard Liengme Charts and Charting in Excel 0 November 26th 04 05:25 PM


All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"