Hi guys,
Need some help with this please.
I have a chart that sources its data from another worksheet. The dates on
the bottom axis need to run from 08/08/09 to 27/03/10. Currently they run
fine up until the 13/03/10 when just a number is returned rather than the
date.
On the source document, the axis is pulling from cells in a row that goes
from 08/08/09 up until 27/02/10 - then from 06/03/10 onwards, the cells are
in a different row.
I am splitting the dates on the chart into fortnightly (30/01/10, 13/02/10,
27/02/10 . . . ) and it just isnt pulling the dates from the second row.
I have formatted all the cells in question, have formatted the chart etc but
cant seem to sort this out.
I hope this clear? Can anybody help??

Hi,

I have figured this one out.
Problem was that 1 row was formatted to 'General' and the other to 'Date'.
Thought I had checked this but apparently not!

"J.Scargill" wrote:

Hi guys,
Need some help with this please.
I have a chart that sources its data from another worksheet. The dates on
the bottom axis need to run from 08/08/09 to 27/03/10. Currently they run
fine up until the 13/03/10 when just a number is returned rather than the
date.
On the source document, the axis is pulling from cells in a row that goes
from 08/08/09 up until 27/02/10 - then from 06/03/10 onwards, the cells are
in a different row.
I am splitting the dates on the chart into fortnightly (30/01/10, 13/02/10,
27/02/10 . . . ) and it just isnt pulling the dates from the second row.
I have formatted all the cells in question, have formatted the chart etc but
cant seem to sort this out.
I hope this clear? Can anybody help??