Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
exporting multiple graphs from excel to powerpoint | Excel Discussion (Misc queries) | |||
Linked Excel graphs in PowerPoint | Charts and Charting in Excel | |||
Excel graphs in PowerPoint | Charts and Charting in Excel | |||
Link to powerpoint resizing graphs | Excel Worksheet Functions | |||
Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) |