Hi,
I have a scenario, wherein I want to draw a bar chart with 2 level grouping. I am getting the data as datatable from database. My actual scenario matches below example.
Example:
I have 4 cities. In the graph I want to display the three month status of each city.
in each month, the city has three status. either it can be in red, green, or yellow with the value as 100%. In similar way I have the data for three months.
This looks like, I have 9 seeries, wherin it will display only three at any given point for one city.
My requirement is to display the city name and month name on X-Axis.
Also the month name should be displayed under correct bar, since the the location of the bar may vary based on the status in that month.
The structure of the table is :
There are nine columns for each city to define the status in three months, since we are having the data as 100% in only three columns any time. There should be only three legend item, which says the colour.
I managed to create the chart with secondary X-Axis for the city name. However I am having trouble with displaying the correct tooltip (not able to append the city name). Also it clubs all the three months names while displaying the label in the x-Axis, due to this, the month name is displayed correctly right below the bar.
Any help is highly appreciated.
Thanks,
Sunil.
