MSGraph is not MSExcel. The data area behind an MSGraph chart is not an
excel worksheet. Perhaps that is your problem - trying to treat them the
same.
--
Regards,
Tom Ogilvy
"Hari Prasadh" wrote in message
...
Hi Jon,
He prefers doing it the hard way....
As I said in the one of the earlier posts, the charts/graphs in each of
the
slides have too much of custom formatting along with charts being of
different types, Stacked/simulating average line/Pie chart, Color of
chart,
Placement of charts in the slides, font of the labels and hundreds of
other
stuff. Also, this same stuff needs to be done for tons of slides, so
making
charts in excel is too much of a pain (will require more coding).
I got the idea of updating charts template charts with new data (and
saving
it with new name) from MS site where they have provided code for Updating
an
MS graph applet. But it seems now have run in to other limitations.
Thanks a lot,
Hari
India
"Jon Peltier" wrote in message
...
He he. Read back aways, and you'll see that Hari abandoned my simpler
suggestion to update the charts in Excel and then put them into Ppt. He
prefers doing it the hard way....
Hari's trying to update Excel charts in Excel workbook OLE objects which
are embedded in PowerPoint. I've been strangely silent on this topic.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Brian Reilly, MS MVP wrote:
Hari,
First mistake is using any of Jon P's instructions. (VBG) Jon is a
good friend and a well respected MVP. But that doesn't stop us from
teasing him (g). As Steve said we aren't sure what you are doing here
(exactly by code)
so can you post the relevant parts. Then we can let Jon Peltier answer
his own mess (vbg). Couldn't resist
Jon, Hari is a recent regular in the PPT NG.
Hari, Jon is a regular stop in in the PPT NewsGroup and works
regularly in Excel and PPT integration all the time. Brian Reilly, MVP
On Tue, 2 Aug 2005 01:18:42 +0530, "Hari Prasadh"
wrote:
Hi,
Im cross-posting/multi-posting this in the hope that I could get a
solution.
I am facing a very strange problem (both in Office 2002 and 2003) with
Excel OLE charts in PPT. (Im programming with excel as base)
I am using code zilched from Jon P's site in order to copy data from an
excel sheet and activate a PPT application (and Slide) and an Excel OLE
object within the slide and then updating the data in it and then
saving
this template with a NEW NAME.
Im using this method to update a single slide template tons of time and
each time saving it with different (but well-defined) names.
Situation: - The new data gets pasted in the Excel worksheet behind the
chart (within PPT) and then the chart also gets updated and then I do a
Save As (using code) to save it with a new name and in a new location
and
then close the file.
I then exit out of the code and then open the file manually and in the
slide show mode can see the UPDATED data but if I try to get in to
editing mode of the Excel OLE chart within PPT then the chart SUDDENLY
displays the old data and the excel worksheet also displays the old
data??
If I escape out of the OLE and do Ctrl + Z then it shows the data
updated
through Macro.
Couple of my colleagues were running tests and they see that if they
save
the file manually after updating data through Macro then the same
problem
doesnt recur? Im not very sure why it is so and nor Do I know whether
the
above observation about manual saving is correct for all situations.
For me manual saving is not an option.
We are also experiencing the same problem in updating excel worksheets
within PPT's.
Can anybody please guide me as to what is happening here?
Regards,
Hari
India