Date Conversion

[Sewak]

I have excel data like below

Date Sales 1 Sales 2
2011-1 200 300
2011-2 328 400
2011-3 232 200
2011-4 232 100
2011-5 211 200
2011-6 128 249

Problem 1: I need to show Chart Scatter chart ( WEEKLY) .
Problem 2: When i change data format of DATE it becomes 1900/0/1

[FDibbins]

Hi, welcome to the forum

Problem 2: When i change data format of DATE it becomes 1900/0/1

Thats because your "dates" are actually text. I suggest you use this in a helper column to make them dates. You can them either use this as your date column, or copy/paste values over your "dates"

=DATEVALUE(A2&"-1")

[Sewak]

Thanks FDibbins

But still have some problem.

I got unnecessary dates

Please see attachment,

[Punnam]

Hi,

Is this what your are trying to achieve i am not sure

Punnam

[Sewak]

No,

There are still date before 2011. I have to show only data of 2011, 2012,2013. Excel is showing date before 2011 ( i.e up to 1900)

[Punnam]

Hi Sewak ,

Point out the same in the workbook which was uploaded in post 4 . & Color the changes .

Punnam

[Sewak]

Thank you Punnam

But I have to show original date in x axis like below

01/01/2011 01/02/2011 01/03/2011 01/04/2011

[Punnam]

Hi,

Check this .

Punnam

[Sewak]

Same excel file Poonam like bfore.

Look at the x -axis. The date are not same as in table

[Indi_Ra]

That is what you are looking for?

[Sewak]

@Indi_ra

Thanks for awesome help.

by the way how did you put that date over there?

[Punnam]

@ Sewak ,

My name is Punnam Ravi not "Poonam"

Punnam