Prev: Time-date chart plotting
Next: Axis labels wrap until print/print preview
From: J.Scargill on 12 Apr 2010 08:57
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??
From: J.Scargill on 12 Apr 2010 11:02
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??
 | 
Pages: 1
Prev: Time-date chart plotting
Next: Axis labels wrap until print/print preview