Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
office 07: auto powerpoint charts using named range data in excel
i am trying to create code that goes down a list of named excel ranges and
creates a complete ppt chart (title with graph and annotated text), one for each excel range. the chart will be customized based on the contents of the named excel range. there may be easier ways, but i thought that if i could reference and change the ppt chart data directly from the excel file procedure, i can set it equal to the excel file data range name that i want. i have been trying to use sourcedata and chartdata but i keep getting compiler errors. any help is welcome, even if it is a reference book that i can buy. thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Noy able to update the PowerPoint charts with the data from ExcelS | Charts and Charting in Excel | |||
Named-range source-data for pie charts on copied worksheets | Charts and Charting in Excel | |||
Excel spreadsheets with data, Powerpoint charts... and VBA! | Excel Discussion (Misc queries) | |||
copy named range to powerpoint | Excel Worksheet Functions | |||
not able to edit XL data in MS Powerpoint in office 2003 | Excel Discussion (Misc queries) |