Bar Chart with grouped X-axis

afp

Hello.<br />
<br />
A fairly simple and quick question.<br />
I would like to make a Bar Chart with grouped X-Axis.<br />
<br />
I have data in the form of;<br />
<br />
<idnr>,<department>,<category>,<produced>,<defective><br />
<br />
And as the diagram-example below shows, I want the department to be the primary group and category the second.<br />
<br />
I have not yet figured out how to do this though, and start to suspect it is not possible?<br />
<br />
<br />
<br />
In Excel, the diagram looks like this;<br />
<img src='http://i.imgur.com/dgcob.jpg' alt='Posted Image' class='bbc_img' /><br />
<br />
Thank you for any tips or ideas.<br />
<br />
(Birt 3.7.0)

mwilliams

You could put the department as the x-axis and the category as the optional grouping field. It wouldn't look exactly like you're wanting, but it would do close to the same. The other thing you could do is to just combine the fields into a single field for the x-axis, department first and category second. Again, it wouldn't look exactly like you want in your image, but it would be similar. You'd probably have to modify the chart source code to get the functionality that you're looking for, exactly.

Hope this helps.