Graphs based on a DATASHEET in powerpoint - Automate from Excel

[Hari Prasadh]

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. I
know a little Excel (along with a bit of VBA).

Now some details.

The text and charts/graph are in Excel. I have consulted Jon Peltier's Site
and have been able to modify it to my requirements. Only change was JP was
pasting as a picture and I wanted the data behind the chart as well, so I
used instead of doing -- ActiveChart.CopyPicture Appearance:=xlScreen,
Size:=xlScreen, _ Format:=xlPicture -- I did --ActiveChart.ChartArea.Copy--
and this way within powerpoint I can open up Excel. This is because the
particular slide required the complete worksheet also in powerpoint.

But, 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).

Please guide me for the same.

Thanks a lot,
Hari
India

 

[Steve Rindsberg]

Hari,

It sounds as though you have a mix of Excel charts and MSGraph graphs in the
presentation.

In PowerPoint, try Insert, Chart. See if that produces the same result as what
you already have. The chart itself may look different, but how about the
behavior?

 

[Hari Prasadh]

Hi Steve,

Thnx a lot. It seems to be the same as Excel chart.

One question (though I have just asked the same question to Jon P in the
charting group as well).

For my purpose the end result of 2 methods of creating Editable charts in
powerpoint are the same. I wanted to ask about the pros and cons of
programmatically
a) pasting in to powerpoint with the excel workbook data Vs
b) using DATASHEET/GRAPH. (Jon P provided me the MS KB link for doing this
programmatically).

In all what DEMANDS/NEEDS make one choose between a) or b) while making
editable graphs? In my case, the sample presentation was made using a
mixture of datasheets kind of graphs and workbook kind of graphs. All the
graphs are of simple type. Nobody in my company knows why such a combination
was made. I think client might not have asked for this mixture. So am at my
wits end as to why within the same presentation, ONE slide has
datasheet-graphs while the OTHER slide has excel workbook graph. Are there
ANY FACTORS OTHER than size/sensitivity due to which one would choose b) in
one situation while c) in another situation? (Both size/sensitivity of
sharing data has already been dealt with by pasting data in to empty excel.)
(And yes am sure that both the slides have been generated automatically
since there are 500 such presentations..)

Thanks a lot,
Hari
India

 

[Steve Rindsberg]

Hi Hari,

For my purpose the end result of 2 methods of creating Editable charts in
powerpoint are the same. I wanted to ask about the pros and cons of
programmatically
a) pasting in to powerpoint with the excel workbook data Vs
b) using DATASHEET/GRAPH. (Jon P provided me the MS KB link for doing this
programmatically).

Can you clarify what you mean by DATASHEET/GRAPH? I'm not sure I can give you
any good idea which to use but want to be certain that I'm not talking about
something completely different from what you mean.

In all what DEMANDS/NEEDS make one choose between a) or b) while making
editable graphs? In my case, the sample presentation was made using a
mixture of datasheets kind of graphs and workbook kind of graphs. All the
graphs are of simple type. Nobody in my company knows why such a combination
was made. I think client might not have asked for this mixture. So am at my
wits end as to why within the same presentation, ONE slide has
datasheet-graphs while the OTHER slide has excel workbook graph. Are there
ANY FACTORS OTHER than size/sensitivity due to which one would choose b) in
one situation while c) in another situation? (Both size/sensitivity of
sharing data has already been dealt with by pasting data in to empty excel.)
(And yes am sure that both the slides have been generated automatically
since there are 500 such presentations..)

Thanks a lot,
Hari
India