Dates Incorrect in Chart
 

I am creating a simple line chart with dates and values. The dates are of
the form 2-Apr-08 (ie custom format) but in the graph they display as
26-Apr-12. Note the data has dates every week but the graph displays these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim

Dates Incorrect in Chart
 

Are the dates in the sheet numeric dates, or text that looks like dates?
What's the number format of the axis tick labels?
Is it a date axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
I am creating a simple line chart with dates and values. The dates are of
the form 2-Apr-08 (ie custom format) but in the graph they display as
26-Apr-12. Note the data has dates every week but the graph displays
these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim

Dates Incorrect in Chart
 

Jon
The dates in the sheet are formatted as dd-mmm-yy and this is also the
format in the axis

Jim

"Jon Peltier" wrote:

Are the dates in the sheet numeric dates, or text that looks like dates?
What's the number format of the axis tick labels?
Is it a date axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
I am creating a simple line chart with dates and values. The dates are of
the form 2-Apr-08 (ie custom format) but in the graph they display as
26-Apr-12. Note the data has dates every week but the graph displays
these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim

Dates Incorrect in Chart
 

Are the dates in the sheet numeric dates, or text that looks like dates?
Does the category axis reference for the series point to the right range in
the worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
Jon
The dates in the sheet are formatted as dd-mmm-yy and this is also the
format in the axis

Jim

"Jon Peltier" wrote:

Are the dates in the sheet numeric dates, or text that looks like dates?
What's the number format of the axis tick labels?
Is it a date axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
I am creating a simple line chart with dates and values. The dates are
of
the form 2-Apr-08 (ie custom format) but in the graph they display as
26-Apr-12. Note the data has dates every week but the graph displays
these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim

Dates Incorrect in Chart
 

Jon the dates in the sheet are numeric dates formatted as dd-mmm-yy and i do
calcuations with them so they are not text. And the axis reference for the
series points to that range of dates

Jim

"Jon Peltier" wrote:

Are the dates in the sheet numeric dates, or text that looks like dates?
Does the category axis reference for the series point to the right range in
the worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
Jon
The dates in the sheet are formatted as dd-mmm-yy and this is also the
format in the axis

Jim

"Jon Peltier" wrote:

Are the dates in the sheet numeric dates, or text that looks like dates?
What's the number format of the axis tick labels?
Is it a date axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
I am creating a simple line chart with dates and values. The dates are
of
the form 2-Apr-08 (ie custom format) but in the graph they display as
26-Apr-12. Note the data has dates every week but the graph displays
these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim

Dates Incorrect in Chart
 

Just checking that you understand, and you do.

Is this a problem on other charts as well? Can you build a duplicate chart
from scratch? Does it display correctly, or is it also faulty?

(In case you can't tell, I'm at a bit of a loss.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
Jon the dates in the sheet are numeric dates formatted as dd-mmm-yy and i
do
calcuations with them so they are not text. And the axis reference for
the
series points to that range of dates

Jim

"Jon Peltier" wrote:

Are the dates in the sheet numeric dates, or text that looks like dates?
Does the category axis reference for the series point to the right range
in
the worksheet?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
Jon
The dates in the sheet are formatted as dd-mmm-yy and this is also the
format in the axis

Jim

"Jon Peltier" wrote:

Are the dates in the sheet numeric dates, or text that looks like
dates?
What's the number format of the axis tick labels?
Is it a date axis?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim" wrote in message
...
I am creating a simple line chart with dates and values. The dates
are
of
the form 2-Apr-08 (ie custom format) but in the graph they display
as
26-Apr-12. Note the data has dates every week but the graph
displays
these
all as 26-xxx-12 (where xxx= one of the months).
What is wrong - I am using Excel 2007
Thanks Jim