PC Review


Reply
Thread Tools Rate Thread

How to add chart in 2007 from code ?

 
 
=?Utf-8?B?Y2hyaXM=?=
Guest
Posts: n/a
 
      3rd May 2007
In previous office versions I was using the commands below for adding an
Excel chart on current slide.

PPT_SLD.Shapes.AddOLEObject Left:=var_chrt_L, Top:=var_chrt_T,
Width:=var_chrt_W, Height:=var_chrt_H, ClassName:="Excel.Chart.8",
Link:=msoFalse

How can I add chart now in 2007 from code ? (it's not easy now that macro
recorder is removed)

Thanks a lot in advanve.
 
Reply With Quote
 
 
 
 
Shyam Pillai
Guest
Posts: n/a
 
      3rd May 2007
Chris,
Use the new AddChart method:

call PPT_SLD.Shapes.AddChart(xl3DPie,0,0,350,250)


--
Regards,
Shyam Pillai

Animation Carbon: Copy/Paste/Share animation libraries.
www.animationcarbon.com


"chris" <(E-Mail Removed)> wrote in message
news:8325D559-EB6C-4DE5-A7EC-(E-Mail Removed)...
> In previous office versions I was using the commands below for adding an
> Excel chart on current slide.
>
> PPT_SLD.Shapes.AddOLEObject Left:=var_chrt_L, Top:=var_chrt_T,
> Width:=var_chrt_W, Height:=var_chrt_H, ClassName:="Excel.Chart.8",
> Link:=msoFalse
>
> How can I add chart now in 2007 from code ? (it's not easy now that macro
> recorder is removed)
>
> Thanks a lot in advanve.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy chart formatting and chart templates in Excel 2007 Astelix Microsoft Excel Charting 4 4th Mar 2010 04:10 AM
Excel 2007 Chart - determining the color of a chart style Shane Devenshire Microsoft Excel Charting 1 6th Feb 2010 04:09 AM
In Office 2007 can't see chart series values unless chart unprotec Carl Microsoft Excel Charting 0 28th Oct 2009 03:31 AM
Can not insert chart in Excel 2007? Chart does not work right? Janis Microsoft Excel Misc 0 18th Jun 2009 08:31 PM
Chart Error when using Chart Line - Column on 2 Axes in vba code =?Utf-8?B?Sm9obg==?= Microsoft Excel Programming 2 3rd Aug 2007 01:42 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:32 PM.