LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Automated show and hide chart

i am working on a spreadsheet that generates a grpah for me. sometime i dont
need that graph to show up in the spreadsheet rater a message instead of
graph.
is there any macro that can help me do that automatically. the message will
be triggered by a value in a cell and then should hide the graph and display
the message. at the moment i do the same manually. but i have to do it for
over 300 sheets so if i can automate it somehow that will help a lot.
any help.
Thanks
 
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
Show and hide a embedded chart? Bob Charts and Charting in Excel 1 June 17th 09 05:12 AM
How can I show/hide plots in a chart? Two-bit Tony Charts and Charting in Excel 1 May 13th 09 11:15 AM
Want to Hide columns in spreadsheet but NOT hide data in chart. KrispyData Charts and Charting in Excel 1 March 20th 09 04:45 PM
Chart Legend Items: hide/show Richard Ahlvin Charts and Charting in Excel 5 September 5th 05 03:04 PM
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 09:49 AM


All times are GMT +1. The time now is 07:58 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"