Re: Automatic updating of PowerPoint Graph charts from data in exc

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Shyam

Thanks this is now working perfectly, this will save hours of work.

kind regards

Mark

"Shyam Pillai" wrote:

> Change the macro security setting from Very High to Medium and then load the
> add-in.
>
>
> --
> Regards,
> Shyam Pillai
>
> Handout Wizard: http://skp.mvps.org/how
>
> "Matthew" <Matthew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:CF0A5D9B-95F7-4311-A091-CA4C4F580F1E@xxxxxxxxxxxxxxxx
> > Hi Shyam
> >
> > Thanks for the link, I downloaded and unzipped the addin for powerpoint
> > 2000
> > or later, unfortunately it doen't appear to load in PP2003. Is it
> > compatible?
> >
> > regards
> >
> > Matthew
> >
> > "Shyam Pillai" wrote:
> >
> >> Matthew,
> >>
> >> Visit: http://skp.mvps.org/download.htm and scroll down to the bottom of
> >> the
> >> page to download this free add-in: Chart Update add-in.
> >>
> >>
> >> --
> >> Regards,
> >> Shyam Pillai
> >>
> >> Handout Wizard: http://skp.mvps.org/how
> >>
> >>
> >>
> >>
> >> "Matthew" <Matthew@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:045C55B7-B8FF-4F88-82DB-F3C76A572659@xxxxxxxxxxxxxxxx
> >> >I am am trying to automate the updating of of charts in PowerPoint 2003
> >> >from
> >> > data in excel 2003.
> >> > To date two methods have been tried.
> >> > 1) Graphs have been created in excel and then copied and pasted with a
> >> > link
> >> > into PowerPoint. When the PowerPoint presentation is opened, a prompt
> >> > to
> >> > "update links" allows all the graphs to be updated. This solution does
> >> > allow
> >> > the most recent data to be displayed, but as the chart is a picture it
> >> > is
> >> > not
> >> > possible for other colleagues to see the underlying data and edit the
> >> > graphs
> >> > according to their needs.
> >> > 2) Microsoft Graphs Charts within PowerPoint have been created and the
> >> > data
> >> > from excel has been pasted into the datasheet behind the chart with a
> >> > link.
> >> > This format does allow colleagues to amend the chart according to their
> >> > needs. But the problem is that PowerPoint does not prompt the user to
> >> > update
> >> > link when the presentation is opened. The only way to update the charts
> >> > is
> >> > to
> >> > open each of the MS Graph Charts in turn, this then updates the
> >> > underlying
> >> > data. ( A similar problem also appears with Microsoft Excel charts in
> >> > PowerPoint).
> >> >
> >> > Is there a way of automating this process via a macro that would look
> >> > at
> >> > each slide in turn, identify any MS Graph Charts, and then update the
> >> > link
> >> > to
> >> > excel so that the latest data is displayed.
> >> > It is possible that there will be more than one chart per slide, and
> >> > the
> >> > presentations will all be of different lengths.
> >> >
> >> > Any suggestions gratefully received
> >> >
> >> > Matthew
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages