WelshNoob Report post Posted January 23, 2011 I understand the use of <category> element to show x-axis labels e.g. to label sales for Q1, Q2, Q3 & Q4 But what if I want to show those quarter sales over a series of years, say 2008 - 2010? I could rename the labels as Q108, Q208, Q308, ...... Q310, Q410 etc but this would be an inelegant solution. Instead, is it possible to restructure the XML to cope with two levels of label - say Q1, Q2, Q3, Q4, Q1, Q2 ...... Q4 immediately below x-axis, then below that the years but only shown once for each set of Q1-Q4? I have tried to create a chart in Excel (sorry) to paste here but have not been successful. Something like this ... ____________________________________ Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 .......2008.......|.........2009.......|........2010........ Share this post Link to post Share on other sites
