Dates appear wrong in my chart

R

Rockman

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?
 
R

Rockman

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Dates change in X axis! Need help ASAP Please? 4
Creating a Chart on form from selected data in query. 0
Entering Dates 2
Timeline Chart, but not a Gantt 0
Combine Bar with Single Line Chart 5

Top