Here’s a little VBA procedure that gives you a full-screen slide show, displaying all of the charts on the active worksheet.
Dim ChtObj As ChartObject
Application.DisplayFullScreen = True
Application.ScreenUpdating = False
For Each ChtObj In ActiveSheet.ChartObjects
Application.DisplayFullScreen = False
Press Space, Enter, or Esc to go to the next slide. This looks a lot better with Excel 2007.
Who will be the first to beef it up by using the OnTime event?