View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vvaidya@pol.net is offline
external usenet poster
 
Posts: 24
Default Hide & Unhide Charts

Hello:

I would appreciate help with the following:
I have about 5 different charts on a worksheet. Is there a way that I
can hide/unhide the charts so that I can display only one at a time.
I plan to use a List through 'Data', 'Validation', so that the user can
select the chart to be viewed from a drop down list (eg. Chart1,
Chart2,...... Chart5)

Thus when the user selects say Chart 2 from the drop down list, Chart2
is displayed & other charts are hidden.

TIA

Vinay