If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Invalid detail on axis
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?? |
#2
|
|||
|
|||
Invalid detail on axis
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?? |
Thread Tools | |
Display Modes | |
|
|