Show Two 'levels' Of X-Axis Label

Recommended Posts

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


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now