Format of dates on x-axis of charts

[Melvinrobb]

Hi all
First time posting on the forum, so I apologize if I don't explain myself that well with this issue.
The issue I am having is with formatting of the x-axis of charts I am making.
I am making a chart for shipments for every month.
For example, for the month of June, the X -Axis is drawing from "=June!$D$9:$D$39".
When I change the format of cells d9:d39 from *Wednesday, June 1, 2012" to "1-Jun", the format of the x-axis changes accordingly.
What I want is for the cells to have the "Wednesday, June 1, 2012" format, but the x-axis to have the "1-Jun" format ( a shorter format is better for the chart).
I can not seem to get the x-axis to be a different format than the cells.
At first I thought this was unavoidable, but I noticed some of the months are capable of having different formatted x-axis and cells.
I finally figured out that the determining factor was whether the months were 31 days, or 30 days.
For the 30 day months the x-axis can not be different than cells d9:d39.
For the 31 day months the x-axis can be a different format.
Does anyone have any ideas how I can have different formats for all 12 months?
Thanks in advance!

[NickyC]

Hi
I think the problem is that for 30-day months you are including row 39 in your source data, and because excel does not recognise this as a date, it is not applying date formats to your date range in the chart. Try changing your data source to d9:d38 and see if this solves your problem (you also appear to have two identical charts on top of oeach other, but that shouldn't be an issue)

[Melvinrobb]

Thanks.
I was thinking that might be the issue.
I wanted it to always be d9:d39 for every month, but when I copy and paste the whole sheet I need to go into the chart and change the source data anyway, so it won't be a big deal to change it to d38.
Thanks for the help!