Excel Charting - Arrange Date Labels diagonally 1

[IngDep]

Having a challenge trying to diagonally display date labels on a graph and protect the graph.

The data table displays the dates as "May-2007", "Jun-2007", etc. but upon highlighting the cell,5/1/2007 and 6/1/2007 is displayed, respectively.

Currently displayed is something similar to;

Ma
y-
07

Ju
n-
07

Any insight sincerely appreciated.

Thanks in advance.

 

[SkipVought]

Hi,

Understand that DATE VALUES are NUMBERS, like 32567. The DATE VALUES can be DISPLAYED any number of different ways, depending on how you FORMAT the DATE VALUE.

faq68-5827

Select the Axis, and select the desired format for your dates in the NUMBER tab. Then look at the ALIGNMENT tab and align as desired.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}