MultiLayer Pivot Chart

Hi

I have attached a workbook to help show what I need help with.

I have a horizontal bar Pivot Chart. On the Y axis I need years grouped by Branch.

i need each year to be a different color.
I need the year to show for a Branch even if there is no data for that year for that branch.
I need the two levels of labels on the Y Axis to both read left to right parallel with the X Axis.

I have spent the day trying to achieve the above but can't

Can someone help please.

Thank You for your help

Allister


Allsiter

To show all the years, turn on "Show items with no data" > Field Settings > Layout & Print > Show items with no data.

To have the year lines in different colors, add in another Year column in source data and in PivotTable, drag this field to columns.