Jim,
Thanks for your response. Let me start by saying that I am an
experienced user of Excel and PowerPoint. In fact, I was a beta tester
for Excel back in 1985 and a beta tester for PowerPoint in 1985
(before it was purchased by Microsoft.
I tried your solution. I find it very inelegant and not a timesaver,
I prepared a sample PPT presentation with three test charts. I saved
my Excel file and PowerPoint file after I imported the charts into
PowerPoint in the manner you suggested.
I then changed the data and chart formats. I returned to PowerPount
and doubleclicked on the chart that needs updating. I am taken to
Excel, but not to my original spreadsheet or chart. Instead I'm taken
to something called "Worksheet in test.ppt." "Test.ppt" is the name of
my PPT file. Worksheet in test.ppt has the orginal formatting and
data, it does not have my changes to either the formatting or data. Am
I to update the data and formatting on each chart individually? This
is more difficult and time-consuming that pasting each chart
individually, at least I can adjust my data more easily.
This should not be such big a deal. All I wantPowerPoint to do is take
the updated chart (data and format) directly from Excel without me
having to individually modify each chart. I cannot be the only person
who would like software to perform this dudgery. Any suggestions?
EV
"Jim Gordon" <goldkey74[at]hotmail.com> wrote in message news:<eiuTdzBTDHA.2228[at]tk2msftngp13.phx.gbl>...
> Hi
>
> There are several different ways to link a graph in PowerPoint to a workbook
> in Excel. I'll describe just one of them. If this isn't exactly what you
> had in mind, please post a follow-up message to the newsgroup.
>
> Start by opening PowerPoint in the normal PowerPoint view with a blank
> slide. From PowerPoint's menu choose Insert > Object > Microsoft Excel
> Worksheet > OK. Wait a moment for the worksheet to appear. You're now
> working in Excel (notice the upper left corner of your screen now says Excel
> instead of PowerPoint).
>
> From Excel's File menu choose Open and then open the workbook that you wish
> to use as the data source. Now I have to be clairvoyant here since I don't
> know whether or not your graph is floating on a worksheet or is a worksheet
> itself. Let's say the chart is floating and you want to keep it that way in
> Excel and still link it to a copy of the graph in PowerPoint.
>
> Select the graph in Excel. Use Edit > Copy, select a cell a little distance
> away and then Edit > Paste. You should have an exact copy of your graph.
> With the copy of the graph selected, from the menu choose Chart > Location
> and then change the location button to "As a new sheet." Give the sheet a
> name and click OK. Now your graph's copy is on a sheet all by itself and
> your original graph is still safely where it was. (If you change any of the
> source data at this point you'll see that both graphs change instantly, so
> you know all is well.)
>
> With the new full page chart worksheet showing, go to the Excel menu and
> choose Edit > Move or copy sheet. In the "To Book:" drop down box select
> "Worksheet in <Presentation's Name>" then click OK.
>
> Now your copy of the graph is in PowerPoint Excel worksheet, but you are
> still working in Excel. Close the window that has the chart in your
> presentation and then Quit Excel. Now save the PowerPoint presentation that
> has the graph and quit PowerPoint.
>
> Just to make sure everything works right, open up the Excel source
> presentation in Excel and change the source data, save the workbook and then
> close Excel.
>
> Next, open the PowerPoint presentation with the linked graph. The graph data
> will need to be refreshed from the data source. Double-click the graph,
> which will open Excel. From the Excel menu choose Edit > Links then click
> the "Update Now" button. The graph will then instantly update without
> opening the source file.
>
> This should verify that the link works. Click Close to close the Links
> dialog box then choose File > Close and Return to <Presentation's Name>. The
> graph is now updated in the presentation.
>
> Sure hope this helps.
>
> You can easily cause the link to fail by doing anything that changes the
> name or location of the Excel source workbook. If you break the link, you
> can re-connect the graph in PowerPoint to the source workbook using Edit >
> Links.
>
> -Jim Gordon
> Mac MVP
>
> All responses should be made to this newsgroup within the same thread.
> Thanks.
>
> About Microsoft MVPs:
> http://www.mvps.org/
>
> Search for help with the free Google search Excel add-in:
> <http://www.rondebruin.nl/Google.htm>
>
> ----------
> In article <5746e5d4.0307160419.1011ad42[at]posting.google.com>,
> edvolchok[at]nyc.rr.com (Edward Volchok) wrote:
>
>
> >
> > Is there a way I can automatically update charts pasted/imported into
> > PowerPointX when I change the data in Excel?
> >
> > In Mac OS 6 or 7 there used to be a publish and subscribe feature that
> > would automatically update objects pasted into other programs.