Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / October 2007

Tip: Looking for answers? Try searching our database.

how do I create a chart with cells that change when clicked on?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DigiPics Design - 02 Oct 2007 02:25 GMT
I need to create a chart for a live presentation at a sale. I need each cell
to have different information and when clicked on, have it change to 'sold'
Doesn't matter what program as long as I accomplish it.  Any ideas????
PPTMagician - 02 Oct 2007 03:07 GMT
There are a couple of ways you could do this:
Use animation triggers to make the sold appear when the item is clicked (but
this only lasts for the duration of the slideshow.  So if you exit the show,
everything reverts.
Use VB, see:
http://weblogs.asp.net/stevencohn/archive/2005/01/12/hide-shapes-on-a-powerpoint
-slide.aspx

Signature

Thanks,
Glenna Shaw
Microsoft PowerPoint MVP Team
http://www.pptmagic.com

> I need to create a chart for a live presentation at a sale. I need each cell
> to have different information and when clicked on, have it change to 'sold'
> Doesn't matter what program as long as I accomplish it.  Any ideas????
John Wilson - 02 Oct 2007 06:49 GMT
As Glenna says probably triggers will do this as long as the change is only
until you close (probably?). There's a tutorial here on our site and if you
google there are more out there.http://www.pptalchemy.co.uk/Triggers1.html

If you do want to use vba to make semi permanent changes to the slide be
aware that the vba snippet in the link won't work during a presentation but
only in edit mode. You could use something like in show mode

sub hideme(oshp as Shape)
oshp.visible=false
end sub

to hide the first shape when it is clicked and reveal the "sold" item.
Sometime code using .visible clashes with other animations (a bug?) so its
best to make the slide animation free.
Signature

Amazing PPT Hints, Tips and Tutorials-
http://www.PPTAlchemy.co.uk
http://www.technologytrish.co.uk
email john AT technologytrish.co.uk

> I need to create a chart for a live presentation at a sale. I need each cell
> to have different information and when clicked on, have it change to 'sold'
> Doesn't matter what program as long as I accomplish it.  Any ideas????
PPTMagician - 02 Oct 2007 13:17 GMT
> If you do want to use vba to make semi permanent changes to the slide be
> aware that the vba snippet in the link won't work during a presentation but
> only in edit mode.

Oops. Thanks for the catch, John.
Signature

Thanks,
Glenna Shaw
Microsoft PowerPoint MVP Team
http://www.pptmagic.com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.