note: before you start slide show run StartEvents macro in ppt On Mon, Mar 28, 2011 at 11:18 AM, ashish koul <koul.ash...@gmail.com> wrote:
> hi deepak > > try this method see if it helps you > > select the month from combo box in ppt it will update the chart in ppt as > well as in excel > > > > open ppt press alt f11 change the location of workbook > > > also always keep chart in a blank worksheet > > On Sun, Mar 27, 2011 at 3:44 PM, Rajesh Kunder <kunder....@gmail.com>wrote: > >> Hi, let me re-iterate your problem. You are trying to copy data from >> excel sheet and put it into a linked excel sheet in the PPT to create >> graphs right? This can be done in VBA using OLE objects but >> unfortunately we cannot do it in Excel 2007 as this feature has been >> taken off. Having said that you can definitely do this in earlier >> versions of Excel. >> >> On 3/27/11, Deepak Pal Singh <deepaktheind...@gmail.com> wrote: >> > Hi Ashish, >> > >> > I'd attached the PPT in my last mail & you can find the charts source >> data >> > in the embedded excel file. You need to right click on the chart & then >> > click on edit option.. >> > >> > Thanks.. >> > >> > On Sun, Mar 27, 2011 at 11:21 AM, ashish koul <koul.ash...@gmail.com> >> wrote: >> > >> >> can you attach the source data as well >> >> >> >> >> >> On Sun, Mar 27, 2011 at 9:58 AM, Deepak Pal Singh < >> >> deepaktheind...@gmail.com> wrote: >> >> >> >>> Hi Guy's, >> >>> >> >>> I'm still waiting for your help... >> >>> >> >>> ---------- Forwarded message ---------- >> >>> From: Deepak Pal Singh <deepaktheind...@gmail.com> >> >>> Date: Sat, Mar 26, 2011 at 7:55 PM >> >>> Subject: $$Excel-Macros$$ Edit Data In Embedded Excel Charts Within >> >>> Powerpoint Using VBA >> >>> To: excel-macros@googlegroups.com >> >>> >> >>> >> >>> Hi Guy's, >> >>> >> >>> I need your help, I’ve a PPT with embedded an excel file. I want to >> show >> >>> the chart given on the sheet1 of the embedded workbook on my PPT. My >> >>> chart >> >>> has dynamic range whenever I change the month on from the cell “H1” on >> >>> the >> >>> sheet1 the source data gets changed according to the table given on >> the >> >>> same >> >>> sheet. Now I want the same functionality in PPT as well, I’ve tried >> and >> >>> write a code to do this, however I’m getting wrong somewhere, I’m not >> >>> able >> >>> to find what I’m missing..Getting an error message during compilation >> >>> “OLEFormat (unknown member): Invalid request. This property only >> applies >> >>> to OLE objects”, please go through my code and solve my problem. >> >>> >> >>> >> >>> >> >>> Thanks & Regards >> >>> >> >>> Deepak >> >>> >> >>> -- >> >>> >> >>> >> ---------------------------------------------------------------------------------- >> >>> Some important links for excel users: >> >>> 1. Follow us on TWITTER for tips tricks and links : >> >>> http://twitter.com/exceldailytip >> >>> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >>> >> >>> To post to this group, send email to excel-macros@googlegroups.com >> >>> >> >>> <><><><><><><><><><><><><><><><><><><><><><> >> >>> Like our page on facebook , Just follow below link >> >>> http://www.facebook.com/discussexcel >> >>> >> >>> -- >> >>> >> >>> >> ---------------------------------------------------------------------------------- >> >>> Some important links for excel users: >> >>> 1. Follow us on TWITTER for tips tricks and links : >> >>> http://twitter.com/exceldailytip >> >>> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >>> >> >>> To post to this group, send email to excel-macros@googlegroups.com >> >>> >> >>> <><><><><><><><><><><><><><><><><><><><><><> >> >>> Like our page on facebook , Just follow below link >> >>> http://www.facebook.com/discussexcel >> >>> >> >> >> >> >> >> >> >> -- >> >> *Regards* >> >> * * >> >> *Ashish Koul* >> >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830 >> > >> >> >> >> >> >> P Before printing, think about the environment. >> >> >> >> >> >> -- >> >> >> >> >> ---------------------------------------------------------------------------------- >> >> Some important links for excel users: >> >> 1. Follow us on TWITTER for tips tricks and links : >> >> http://twitter.com/exceldailytip >> >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> >> >> <><><><><><><><><><><><><><><><><><><><><><> >> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/discussexcel >> >> >> > >> > -- >> > >> ---------------------------------------------------------------------------------- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to excel-macros@googlegroups.com >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > Like our page on facebook , Just follow below link >> > http://www.facebook.com/discussexcel >> > >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
