I have a pivot chart plotting various things against dates. I have the dates split into weeks - but when you do this it puts in week number, eg Week Number 5, Week Number 6, Week Number 7, with no reference to what the actual date is. Week numbers mean nothing to the people I'm doing this graph for. So to give an idea what the week numbers refer to I also added months to the graph. This then shows Jan - Week 1, Week 2, Week 3, Week 4; Feb - Week 5, Week 6, Week 7 etc which is much better, but! when a week runs over two months like week 14 (March/April) it then gives me two Week 14's on the graph, one for end of March, one for end of April. But we need totals for the whole of each week, not a week being split into two (as it ruins the trend). So how do I plot a graph split into weeks, but give an indication of the actual date or month alongside the week numbers?
Many thanks to anyone that can help, it's driving me demented...