LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default Loop through combo and copy graphs to Powerpoint

I use Excel (and Powerpoint) 2003. In Excel I have a sales graph object on a
worksheet (no chartsheet!), that represents the sales of one particular
product family (in total there are 12 options like "shoes", "tennis rackets",
etcetera).
The selected combobox option is linked to a cell. That number is used again
to select a specific range of data to show salesdata for the selected product
family.

Now I would like to loop through all options and after each display, copy
the graph to Powerpoint.

Any ideas how to set this up?

Sub LoopGraphs_Copy2PP()

Dim i as Integer
For i = 0 to 11
'How do I loop through the combobox (it comes from Forms)? How do I loop
through options?
etcetera.

 
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
exporting multiple graphs from excel to powerpoint JPhish Excel Discussion (Misc queries) 1 March 17th 09 04:39 PM
Linked Excel graphs in PowerPoint MAB Charts and Charting in Excel 0 January 10th 07 03:36 PM
Excel graphs in PowerPoint Meghen Charts and Charting in Excel 2 January 20th 06 10:40 PM
Link to powerpoint resizing graphs Landxlii Excel Worksheet Functions 0 April 6th 05 08:49 PM
Copy and pasting graphs to PowerPoint JZip Excel Discussion (Misc queries) 0 January 6th 05 08:29 PM


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