Vanishing Excel data Plots Viewed in PPT2002 when Created in PPT MacX

  • Thread starter Clinton Winchester
  • Start date
C

Clinton Winchester

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
 
C

Clinton Winchester

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!!
 
Top