I have the following 2D bar chart setup:
X axis - date (each bar is 1 day)
Y axis - sales revenue
One set of data (date, revenue)
The date range spans 2-3 months.
Straightforward enough...
My question: is it possible to display month labels underneath groups of bars?
Due to the x-axis spanning 2-3 months, there needs to be a clear visual separation for the months, whilst keeping it a continuous linear progression of dates.
i.e. the x-axis may span dates 20/09 to 23/11. so we want to show "September" centred underneath bars 20/09-30/09, "October" underneath dates 01/10-31/10 and "November" underneath dates 01/11-23/11?
What I've tried/found:
Looking through the API/documentation I could only find grouping the months into "datasets" and setting up a "category" for each one. The only problem with that is it would group the days of each month next to eachother - whereas they need to be sequential...
Does it need to be multi-series?
Any thoughts? Is it possible - and if so how?
Thanks.