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

Combine Bar with Single Line Chart 5
Dates change in X axis! Need help ASAP Please? 4
Entering Dates 2
Chart bases on user input dates 1
line chart problem when I open file in 2007 1
Chart and date data 2
Charting depending on criteria & data series name as a column val 2
stepping chart 2

Top