Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / April 2008

Tip: Looking for answers? Try searching our database.

Issue! Dates on Excel charts in PowerPoint keep changing!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
baconcow - 11 Apr 2008 21:22 GMT
I have a PowerPoint presentation that is composed of mainly Excel graphs that
I have copied and pasted from an existing Excel spreadsheet. I am having one
issue with two results that both occur whenever I close the program and then
reopen it or when I save it (also when I print it as an adobe file).

Issues:
- The YEARS along the axis change (i.e. 2007 will become 2003, or sometimes
2011, etc.). The day, however, remains correct. The changes are always the
same, everytime.
- The day keeps shifting one to the left (i.e. Jan 2nd, 2007 will become Jan
1, 2007) for the entire graph. None of the years modify. The changes are
always the same, everytime.

Only certain slides keep doing this, over and over, and in sets (sets
located on the same worksheet). I have tried re-copying them into the
PowerPoint presentation with no fix. I have tried just saving the PowerPoint,
but it doesn't work. I have tried printing it as a PDF, keeps happening. Even
saving it as a 1997-2003 compatible file doesn't help.

I hope somebody has a fix for this or at least a way around it. This is not
the first time that it has happened.

I am using Microsoft Office 2007 with Windows XP Professional with Service
Pack 3 (v.3311). I have Microsoft Office Service Pack 1 installed.

Thanks
Pia Bork - 12 Apr 2008 12:45 GMT
> - The YEARS along the axis change (i.e. 2007 will become 2003, or
> sometimes
[quoted text clipped - 6 lines]
> Only certain slides keep doing this, over and over, and in sets (sets
> located on the same worksheet).

When I played around with this option I found only one case to see this
behaviour:
- in Excel 1904-date-system is not activated
- I copy and paste the cells into powerpoint with linking
- I activate 1904-date-system in Excel
- I update the presentation with printing, print preview or something else

Are the slides that change so odd are from the same Excel-file than those
that do not change? I wonder if the Excel-option "use 1904 date system"
plays any role in this behaviour.

Signature

Mit vielen Grüßen
Pia Bork
--
MVP PowerPoint
http://www.ppt-faq.de und http://www.borkoffice.de

baconcow - 13 Apr 2008 02:30 GMT
Some of the graphs are from different Excel workbooks, while others are from
the same workbook, but different worksheets. I will investigate which
workbooks they are from and post my results.

> > - The YEARS along the axis change (i.e. 2007 will become 2003, or
> > sometimes
[quoted text clipped - 17 lines]
> that do not change? I wonder if the Excel-option "use 1904 date system"
> plays any role in this behaviour.
Echo S - 12 Apr 2008 15:41 GMT
This may be the same issue I ran into during beta with axis numbers changing
to weird stuff, I don't know. But run Diagnostics (Office Button | PPT
Options | Resources) and see if that fixes it. Also make sure you've applied
SP1 for Office 2007.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

>I have a PowerPoint presentation that is composed of mainly Excel graphs
>that
[quoted text clipped - 30 lines]
>
> Thanks

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.