excel chart x axis

[okl]

Hi,

As seen on the screen attached, how do i create the same date format for every 1,2,3 for my x axis too?

Thanks

[Andy Pope]

You can get a similar affect by using multi level category labels.

Post workbook if you need more help

[Jon_Peltier]

It won't have the little brackets, but the approach I've written about in "Chart with a Dual Category Axis" gives you something very similar.