Lost data from chart created via VBA from excel.

C

CMK08

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top