Showing Excel charts as a slideshow?

[Rolf Barbakken]

I need to loop through all charts in a worksheet/-book and display them in a
slideshow - graph by graph. I want the user to be able to start this
slideshow with a button in the workbook and go back/forward in the slideshow
with mouse- or keyboard navigation.

Anyone know of a good way of doing this?

 

[Tushar Mehta]

If the number of charts does not change, create a PowerPoint
presentation with one chart per PP slide. Make sure you copy + paste
link each chart. That way when the chart changes the PP file will also
be updated.

The user can now run the PP slide show.


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

 

[Rolf Barbakken]

The number of charts will change, and one of the reasons for creating a
slideshow in Excel is that they do not want two files - one Excel and one
PowerPoint. So I embedded the PowerPoint-presentation in the workbook, but
this didn't work either. PowerPoint links to the workbook, and if the user
copies the workbook the embedded presentation will still get its data from
the original workbook - making the excel-file impossible to use as a
template.

I have found a way to loop through all charts in a worksheet, but have not
yet found code that can show the charts full screen and with navigation
methods.

 

[Tushar Mehta]

{snip}

I have found a way to loop through all charts in a worksheet, but have not
yet found code that can show the charts full screen and with navigation
methods.

Effectively, you are trying to recreate some of the capabilities of a
program such as PowerPoint. Obviously it is not impossible. You could
do create a 'slide show' by putting each chart in a chartsheet and
adding appropriate navigation controls on that chart sheet. The
navigation controls could be autoshapes with the appropriate code for
each. Of course, I suspect you will find that as you add basic
capabilities, you will be asked for additional slide show related
features.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005