PROBLEM REPORT

Powerpoint version now in use: 2003

Version the file was created in or opened in since, if any: 2003

Windows version: XP

Other hardware involved (printer, etc): none

Description of problem:

We are using VBA in Excel to build powerpoint presentation with data from
in the spreadsheet. After a step through the vba code we determined that the
saving action is causing the data inserted intot the bar charts to disappear.
We are able to see the charts after saving the presentaion but the charts
disappear once we click on them to access the data (they do not come back if
we save changes to ppt after clicking the graph). This only happens with
graphs, all other objects populated in the same way are fine.

When I do this: click on graph

Here's what happens (include text of any error messages that appear):

no error messages appear, the data used to populate the bar graph
disappears and so does the graph (since there is no data to be displayed)

or

Here's what I expect to happen, but it doesn't:

Here's what I've already tried to solve the problem: used variables to
populated datasheet in the ppt, then tried using copy and paste.

Re: Lost data from chart created via VBA from excel. by Steve

Steve
Wed Oct 08 12:19:24 CDT 2008

If you're automating MSGraph to create the charts, you need to call the MSGraph
application's Update method before calling Quit. Sounds like that might be the
problem here.

In article <87E5F9D6-58FE-4E23-9C95-031951E25781@microsoft.com>, Cmk08 wrote:
> PROBLEM REPORT
>
> Powerpoint version now in use: 2003
>
> Version the file was created in or opened in since, if any: 2003
>
> Windows version: XP
>
> Other hardware involved (printer, etc): none
>
> Description of problem:
>
> We are using VBA in Excel to build powerpoint presentation with data from
> in the spreadsheet. After a step through the vba code we determined that the
> saving action is causing the data inserted intot the bar charts to disappear.
> We are able to see the charts after saving the presentaion but the charts
> disappear once we click on them to access the data (they do not come back if
> we save changes to ppt after clicking the graph). This only happens with
> graphs, all other objects populated in the same way are fine.
>
> When I do this: click on graph
>
> Here's what happens (include text of any error messages that appear):
>
> no error messages appear, the data used to populate the bar graph
> disappears and so does the graph (since there is no data to be displayed)
>
> or
>
> Here's what I expect to happen, but it doesn't:
>
> Here's what I've already tried to solve the problem: used variables to
> populated datasheet in the ppt, then tried using copy and paste.
>

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================