Grouping in X axis

SindhuRM

Hi...In my requirement i have the X axis of the chart which should have two groups...
For example...organization is the first grouping and then we have the Department wise grouping.


How it has to look is that...
Inside XYZ Organization.... I have two Departments like"Sales and Finance"
This should be displayed in chart .

How it can be done in X axis.Two grouping..
Can anyone help me ASAP....

gcottle

Hi SindhuRM,

On your chart, if you set your category (X) series to “Departments” and enable grouping on the X axis, and then set your “Optional Y Series Grouping” to “Organization”, then the chart will show the departments grouped according to organization.

Regards,

Graham