Hi Jon,

Thnx a lot for offering information on BOTH -- convert these charts into
Excel charts -- and -- Or you can try the VBA example --.

Based on the whims of my manager I would be able to use both of them
depending on the needs of the situation.
I liked the KB article a lot, can copy the code as it is.

> The symptoms you describe indicate an infection with MSGraph, the small
> Office Applet used by PowerPoint and Word (and I guess by Access) for
> simple charting. These charts were not created in Excel.
You named it as -- MSGraph -- To check whether/why it not available in Excel
I went to Insert - Object - createnew object --Microsoft graph chart and am
able to get such data sheets in Excel as well.

One doubt.
> the small Office Applet used by ...... for simple charting.
Based on your usage of the word -- simple charting-- I wanted to ask about
the pros and cons of
a) pasting as a picture Vs
b) pasting with the excel workbook data Vs
c) using DATASHEET/GRAPH.

I have read through the notes in your web-site and here are some of my
thoughts based on the same.

Somehow Im not much enthused by option a). Because once I have made the
graphs automatically then another person (co-employee/manager/client/) might
like to check whether the graphs have been made correctly or not. Problem
with a picture is that *automatic/easy comparison* is not possible. It's
like a picture would have value labels but one would have to visually
compare those value labels with the base workbook. On the other hand if
powerpoint contains the data in a workbook (assuming that the OLE workbook
contains only graph data) along with the graph then if one double-clicks on
it comparatively easier/automatic comparison could be done between this OLE
workbook and base workbook by using IF formulas etc..

Also, if data changes slightly on a later data for the same powerpoint
presentation then the client or co-employee could just change that single
data point and still get the job done. Not only that but suppose on a later
data with the same data they want a different CHART TYPE (it's like people
might want to *experiment* with choosing a chart which best complement the
*data* available on the hand) then picture wouldnt work.
(Not a personal query but... In the course of your charting profession dont
your clients *prefer* or *demand* the ability to edit charts? Whats the best
practice or the prevailing trend in such scenarios. )

With option b) I agree that it bloats the size and sensitive data might be
unintentionally shared. To combat this you have suggested to paste just the
data and chart in to a new empty workbook, which is a nice idea.

Im new to Datasheets. Why are you referring to option c) being for simple
charting only. When I right click on them Iam able to get the same set of
chart types standard and custom as in a normal Excel chart. It even has the
secondary axis chart option. So by simple charts do you mean that it cannot
make fancy charts such as in Andy pope's or Tushar's site. Actually for this
particular slide I need only normal charts. Or is there some LIMITATION
between datasheet-graph and normal excel graph even when we have to make
normal graphs.

In all what DEMANDS/NEEDS make one choose between b) or c) 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
excelworkbook.)
(And yes am sure that both the slides have been generated automatically
since there are 500 such presentations..)

Thanks a lot,
Hari
India

"Jon Peltier" <jonREMOVExlmvp@peltierCAPStech.com> wrote in message
news:Om2KtThDFHA.3728@TK2MSFTNGP14.phx.gbl...
> Hi Hari -
>
> The symptoms you describe indicate an infection with MSGraph, the small
> Office Applet used by PowerPoint and Word (and I guess by Access) for
> simple charting. These charts were not created in Excel.
>
> You can convert these charts into Excel charts, and treat them as all the
> others in the presentation. Or you can try the VBA example in the
> following Microsoft Knowledge Base article:
>
> http://support.microsoft.com/default...b;en-us;267974
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>