B
Basil
Hiya
I'm trying to draw up a chart in a report - Access 97
I want to put dates along the x-axis, but have the x-axis scale to show a tick for each month (mmm yy) - the data could go over multiple years
The problem is that I can't get MS Graph to recognise or give me the scale options of a time axis as it would in MS Excel. If I format the axis to mmm yy - it simply gives me a tick for every date! I cannot simply set a tick every 30(ish) days since there will not be a record every day - and it doesn't recognise the axis as being dates
Can anyone please help/lead me in a good direction
Basil
I'm trying to draw up a chart in a report - Access 97
I want to put dates along the x-axis, but have the x-axis scale to show a tick for each month (mmm yy) - the data could go over multiple years
The problem is that I can't get MS Graph to recognise or give me the scale options of a time axis as it would in MS Excel. If I format the axis to mmm yy - it simply gives me a tick for every date! I cannot simply set a tick every 30(ish) days since there will not be a record every day - and it doesn't recognise the axis as being dates
Can anyone please help/lead me in a good direction
Basil