View Full Version : Vanishing Excel data Plots Viewed in PPT2002 when Created in PPT MacX


Clinton Winchester
08-03-2003, 03:50 PM
Sorry if this is an old and thrashed problem. Newbie to this group.

Is there an easy solution to the loss of Excel graphs (x-y data plots) when
cut/pasted into PPT on Mac PPT X so that they are viewable in a PPT file on
a PC using PPT1997/2000/2002? without migrating the entire 20 MB excel
workbook along with it? Have about 40 slides, each with 20MB-ish excel
wookbooks.

Not just email issue, also disk file transfer issue (sneaker net).

Thanks in advance!!
r/Clint

Clinton Winchester
08-14-2003, 12:05 AM
Hi and thanks.

Had several kilo-row, multi-column data sets being plotted in x-y
scatterplot mode as unsmoothed lines without markers. Since the time base
shifted in the dataset during a run, using the basic "line" (category) plot
with equal spacing would not work well.
Working in MacOS10.2 on a relatively recent G4. Plotted out in excel.
Selected, apple-c to copy, apple-v to paste in PPT. When I do this on a PC
I copy and paste-special as a pict, and paste in an image only.

I had not had this problem in previous renditions of MS Office Mac
interfacing with MS Office PC.

The work around I hit on --eventually -- almost made me start-over on the
PC.

Cut/paste did not work. Had to insert a graph into PPT from EXCEL. When
saved and seen on MS Office XP this still showed the red-x. Double clicking
on the red-x gave a microversion of the data file (just the time base and
the selected data columns), click again and a graph popped in. Had to
reformat. had to recolor. Had to resize. Once reformated and saved was
viewable on both platforms.

Oddly enough - another make life too difficult to bother with solution I hit
on - was making the PPT on Mac and then EXPORTING THE FILE AS A SET OF
GRAPHIC IMAGES (PNG?). This allowed PPT to repaste as images made of the
graphs that did translate over without requiring reformating and retained
the sharper line style from the mac.

Saving this nonsense on the mac as a PDF ended being 24MB, versus 2.3 MB as
a image set on the PC and Mac as PPT.

I'd have to go back and really walk through both the probelm and the "really
bad cure" again for better details. That was 2 weeks ago now.

Thanks!!

"Jim Gordon" <goldkey74[at]hotmail.com> wrote in message
news:eBeR$lgWDHA.2276[at]TK2MSFTNGP10.phx.gbl...
> Hi Clinton.
>
> Well, it's sorta old and kinda thrashed, but not much is really known
about
> this problem.
>
> I've not been able to reproduce the problem. I just tried again. I made a
> X-Y graph (you didn't say which one of the XY graphs you made, so I just
> picked one). I used Apple-X to cut the graph from Excel. I switched to a
> blank slide in PowerPoint. I used Apple+V to paste the graph into
> PowerPoint.
>
> I saved the presentation, and was able to see the graph in PPT 2001 and
PPT
> 2002 (XP). I am using Office X with Service Release 1. My Office XP has
all
> of the latest patches installed.
>
> So what did you do different from me?
>
> -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 <Qi9Xa.32061$Mc.2550379[at]newsread1.prod.itd.earthlink.net>,
> "Clinton Winchester" <ccwinchester[at]earthlink.net> wrote:
>
>
> >
> > Sorry if this is an old and thrashed problem. Newbie to this group.
> >
> > Is there an easy solution to the loss of Excel graphs (x-y data plots)
when
> > cut/pasted into PPT on Mac PPT X so that they are viewable in a PPT file
on
> > a PC using PPT1997/2000/2002? without migrating the entire 20 MB excel
> > workbook along with it? Have about 40 slides, each with 20MB-ish excel
> > wookbooks.
> >
> > Not just email issue, also disk file transfer issue (sneaker net).
> >
> > Thanks in advance!!
> > r/Clint
> >
> >
> >
> >
>