Getting date to show as it is in scatter chart

Set up a pivot table to summarize data and then to get a scatter chart out of it I copied and pasted it as values. So far so good...
However I have brought in the dates, tweaked them and my Revised Date column is looking like a date but alas is not quacking like the proper date in the scatter chart I created from it. The dates are all showing up as 1900 dates instead of the dates as given...even though the dates look like dates. What am I missing here. (Scatter chart is right at end of the data)

Thanks as always. :-)
Scatterchart-not-showing-dates.xlsm
LVL 1
agwalshAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

The dates that you have are not recognized as Dates that's where the problem is

EDIT to change them to Dates insert 0 (Zero) in a cell otherwise nonused

And then PasteSpecial / Operation Add

Maybe you will have to reformat the cells as Date

Regards
Scatterchart-not-showing-datesV1.xlsm
0
 
5teveoConnect With a Mentor Commented:
Reformat your date using new forumula

this formula is repeater in new column to reformat text date.
=DATE(RIGHT(E2,4),MID(E2,FIND("/",E2)+1,2),LEFT(E2,2))

new format will be mm/dd/yyyy

Use this new date column to pivot against.
0
 
agwalshAuthor Commented:
Rgonzo1971 - sigh...worked so well. Thank you :-) Did the job..
Steveo - I tried your formula but got Value message all the way down..but still appreciate the effort.
0
 
agwalshAuthor Commented:
Just to say the reason I allocated the points in this way is that while Rgonzo1971 solved my problem...I also appreciated Steveo's formula and effort :-)
0
 
5teveoCommented:
thanks for points!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.