Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default 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
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
Noy able to update the PowerPoint charts with the data from ExcelS Vinod Charts and Charting in Excel 0 May 4th 07 02:45 PM
Named-range source-data for pie charts on copied worksheets [email protected] Charts and Charting in Excel 4 March 19th 07 05:50 AM
Excel spreadsheets with data, Powerpoint charts... and VBA! Petitboeuf Excel Discussion (Misc queries) 1 May 26th 06 11:15 AM
copy named range to powerpoint confused Excel Worksheet Functions 1 October 17th 05 03:23 PM
not able to edit XL data in MS Powerpoint in office 2003 Sujay Excel Discussion (Misc queries) 2 May 31st 05 04:09 AM


All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"