another graph axis question

[hollandrob81]

hey folk, ive managed to sort out getting my grid lines at the right intervals thanks to your advice. but where it has the dates (1) in the picture, taken from data series (2), i want it to say "1 week, 2 weeks, 3 weeks" etc etc. is ther a way to do this? many thanks

 

[Steve=True]

Part 1: If you want to keep the dates and add weeks, this is a way to create a grouping:

Basically, add a column to the left of your weeks and put the week name only once at the beginning of that week.

Then when you create the graph, add the new column as part of the data set and it will group your axis information.

See this: http://chandoo.org/wp/2010/11/17/sho...ars-in-charts/