Hi,

Somebody in my company had automated powerpoint report containing some text
and charts/graph. The person has left the company and macros arent available
but I have a sample output with me. I have to recreate the macros now. The
data resides in EXCEL and am interfacing to powerpoint by using Jon P's
code.

There is one particular slide in the template with which Iam having a
problem. It has 5 graphs and all of the them seem to be of the same type
look-wise. When I double-click on the graph instead of an excel worksheet ,
a DATASHEET opens up.

a) What is this datasheet?. Difference between this datasheet and having the
full excel workbook available in Powerpoint? I believe that for this slide
the requirement might have been to have not the full excel workbook but the
data behind the graph only. So, is datasheet facility used for that purpose?

b) Im sure that the data for this datasheet must also have come from Excel.
So, my question is how do I automate the production of this graph/datasheet.

c) Can this kind of a graph from datasheets be made in excel? If yes, then
for accomplishing part b) shud I first make the graph in excel and then
paste it in to Powerpoint. If so how to paste them in powerpoint such that I
get the data behind the graphs also (Dont want the full excel workbook). If
this datasheet based graph is available only in Powerpoint then how would
data from excel be converted to graph in powerpoint?

Please guide me for the same.

Thanks a lot,
Hari
India