Dates appear wrong in my chart
 

I have a bar chart I have created from a table. I want the x axis to be the
dates shown in the table. currently 11/01/2007, 11/01/2006, etc. They appear
in the chart as 01/01/2007, 01/01/2006, etc. If I change the formatting in
the chart from date to number than the dates in the chart appear 11/01/2007,
11/01/2006, etc. How do I get both the table and the chart to display the
correct date? Has anyone experienced a simliar problem?

Dates appear wrong in my chart
 

I have a bar chart I have created from a table. I want the x axis to be the
dates shown in the table. currently 11/01/2007, 11/01/2006, etc. They appear
in the chart as 01/01/2007, 01/01/2006, etc. If I change the formatting in
the table from date to number than the dates in the chart appear 11/01/2007,
11/01/2006, etc. How do I get both the table and the chart to display the
correct date? Has anyone experienced a simliar problem?