PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Date format change when using Series() function

Reply

Date format change when using Series() function

 
Thread Tools Rate Thread
Old 15-11-2007, 05:49 PM   #1
=?Utf-8?B?Tk0=?=
Guest
 
Posts: n/a
Default Date format change when using Series() function


I’m using the Series() function with graphs, and the name ranges within the
graphs seem to work, however, the X axis date range now goes weird on me.
The named range for my X axis looked fine before, but when I put the name
range in the Series, the dates are now all wrong (1/1/1900, 2/1/1900, etc).
Any thoughts?

Thank you.
  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off