Dates of embedded Excel chart changed going from Mac to PC

Posted: 11-19-2003, 05:37 PM

Bert

Guest
Posts: n/a

On my Macinsoth (G4, OS X 10.3.1) I created a simple column chart in
MS Office X Excel, then pasted it into a MS OX Powerpoint file. When
I sent the PP file to PC users they reported that the X axis's monthly
date range had become Oct-98 thru Sep-99 rather than the original
Nov-02 thru Oct-03 .

To verify this I opened the original Powerpoint file from within
Virtual PC (W2K). The chart initially came up empty with the infamous
red X in the corner of the chart object. After double clicking on the
red X the chart appeared, resized and, sure enough, the dates had
been changed. In all other respects the chart was accurate. I saved
this PC PP file; when it was opened on my Macintosh the dates
remained incorrect.

Any suggestions?

Responses to "Dates of embedded Excel chart changed going from Mac to PC"

Jim Gordon MVP

Guest
Posts: n/a

Re: Dates of embedded Excel chart changed going from Mac to PC

Posted: 11-20-2003, 03:53 AM

Hi Bert,

You are seeing the 1904 vs 1900 date system difference between Mac and
Windows versions of Excel (which handles the dates for graphs).

This article offers explanations in the section "Setting the date system."
"Crunch numbers across platforms with Excel"
<http://www.microsoft.com/mac/product...singexcelx&typ
e=tips&article=/mac/LIBRARY/how_to_articles/officex/xl_crossplatform.xml>

-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 <ca5c65b.0311191037.1d987f99@posting.google.com> ,
bertkauf@comcast.net (Bert) wrote:

>
> On my Macinsoth (G4, OS X 10.3.1) I created a simple column chart in
> MS Office X Excel, then pasted it into a MS OX Powerpoint file. When
> I sent the PP file to PC users they reported that the X axis's monthly
> date range had become Oct-98 thru Sep-99 rather than the original
> Nov-02 thru Oct-03 .
>
> To verify this I opened the original Powerpoint file from within
> Virtual PC (W2K). The chart initially came up empty with the infamous
> red X in the corner of the chart object. After double clicking on the
> red X the chart appeared, resized and, sure enough, the dates had
> been changed. In all other respects the chart was accurate. I saved
> this PC PP file; when it was opened on my Macintosh the dates
> remained incorrect.
>
> Any suggestions?

LinkBack

Thread Tools

Display Modes

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may post replies You may not post attachments You may not edit your posts BB code is On Smilies are Off [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Photo dates changed, images unrecognized.	Bus Radin	Windows XP Photos	1	07-25-2004 10:15 PM
Putting Legend info on an Excel Chart	R Ramsland	Mac Office Excel	0	05-08-2004 12:45 AM
Animating an excel chart	Jerry Hansen	Mac Office Excel	2	03-02-2004 01:04 AM
Help with Excel chart!	buke120	Mac Office Excel	1	02-05-2004 09:09 PM
Excel chart problem	Martin S Taylor	Mac Applications	0	07-06-2003 03:04 PM