Hi, It is possible to set visibility of chart.
You can use the code given in http://cjoint.com/data/fFrTGZSr2t.htm Do following changes in that code: Instead of "ActiveSheet.Shapes("AutoShape 3").Visible = False" use "ActiveSheet.ChartObjects("Chart 1").Visible = False" Attached is the excel for your reference. Regards, Swapnil. On Thu, Jun 3, 2010 at 8:39 PM, Alfred WALLACE <jos...@gmail.com> wrote: > Thanks a lot KAMAL !!! > > your solution works fine, but, It would be possible to obtain > the same result with a dynamic graph ? > > I'm testing that solution with de MouveMove event of a shape : > like that : http://cjoint.com/data/fFrTGZSr2t.htm > > Do you think is it possible tu activate visibility (true or false) > of an object "graph" ? > > thanks again for you help !! > > José from France. > > On 1 juin, 17:15, kamal shah <kamal...@gmail.com> wrote: > > Its Possible !!! > > > > Here is a solution what you are looking. > > > > Add a Picture to an Excel Comment > > > > 1. Right-click the cell which contains the comment. > > 2. Choose *Show/Hide Comments*, and clear any text from the comment. > > 3. Click on the border of the comment, to select it. > > 4. Choose *Format*|*Comment* > > 5. On the *Colors and Lines* tab, click the drop-down arrow for > *Color*. > > 6. Click *Fill Effects* > > 7. On the picture tab, click *Select Picture* > > 8. Locate and select the picture > > 9. To keep the picture in proportion, add a check mark to *Lock > Picture > > Aspect Ratio* > > 10. Click *Insert*, click OK, click OK > > > > Cheers > > > > KAMAL > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Hide and Display Chart using VBA.xls
Description: MS-Excel spreadsheet
