convert your data using your formula so you will be graphing actual dates.

then once the graph is created, right click on the axis and select format
Axis. then pic the format you want to show or do it with a custom format.

If you need code, turn on the macro recorder while you do it manually.

--
Regards,
Tom Ogilvy

"Rain" wrote in message
...
Hi,

I have data in the following format:
DATE VALUE
10012004 100.1
11012004 120.6
12012004 112.0
15012004 115.8
17012004 118.9

Now, I cannot change this data on the excel sheet. I will need to use this
data to draw a graph which I am doing using VBA. I know that the date in
the
above format can be converted to DDMMYYYY by using say [
=DATEVALUE(LEFT(B9,2)&"/"&MID(B9,3,2)&"/"&RIGHT(B9,4)) ]
How, can I get the graph that gets generated to display dates in
DD/MM/YYYY
format ?

Thanks in advance.