Graph assistance

I rushed this post so if anything is unclear then please ask.

Hi Guys need some help please! just been given a task which has to be done asap and am struggling to come up with a suitable way of showing what they want!

I need to display some Data in graph form.

I have attached the spreadsheet.

Basically this data is the success rate of different ethnic groups by department and needs to be shown in one graph. The aim is to compare how Ethnicities do by department.

Any ideas would be welcome.

So far this is a clso as ive come to something useable but its still s^&*!

Use a pivot table/chart to group and summarize.

I assume the average success rate will have to be the data displayed.

Hi Andy -

Thanks so much dude for looking.

I have re attached your sheet showing how my manic boss want the graph to look. but she wants the largest value at the botton. possible?

Avg success rate NOT to be used - this women is a nut job!!

Not possible as you are wanting to sort series within each category.

Plus it would make it a nightmare to identify each segment of each column as the order would not be consistent. Even now the chart is cluttered and hard to read

Thnks for taking the time too look. I did tell her that the spec for this graph was too broad.

She can explain to her bos why its a sh&t graph!!

Cheers andy

If you use Ethinicity as row label and Department as Report page you can rank the data. But you can only see a single department

theres a thought - how would you rank? ive done the above.ie Ethinicity as row label and Department as Report page

Cursor in the 1st data colulmn of the table.
Pivot Table Tools > Options > Sort > Z-A

Andy thanks so much -

like columbo - i have a final q uestion. is there a way of putting the department name selected from the report filter into the graph as a chart title. thanks very much and sorry to have dragged this out

Assuming Department is being used as the Report page field then,
Select the chart title
In the formula bar enter the cell address of the dropdown. something like,

=Sheet1!b2

The chart title should now update when the report field changes.