Andy,
Thanks for the response but I am still have an issue. Sorry I left that row hidden the rows are:

1 - Week
2- Month
3- Day

I just want the graph to show the Wk and the Day for example I want the chart to state the following for Column D.


Wk 1 - 1/3 This is exactly what I want the axis to say for the first point on the chart. Can I do this?

Thanks,
John