Pie chart with Bar question

[OllyMUK]

Hi

I have the following picot table which I want to visualise as a Pie chart with a breakout bar chart. I want the Pie Chart to show Low, Medium and High and then have a breakout bar chart showing the Account Names that make up the High clients.

Here's my pivot table

Which is based off of this table

What I'm after is for the pie chart to show the High, Medium and Low count, with a breakout from the High slice, detailing the number of Accounts which make up High, and their names. So in the screenshow the Blue and Purple box would actually be ClientA and ClientB.

Can this be done?

Olly

 

[RoryA]

You can use the Format Data Point dialog to choose which points are in the second plot (column), and which are in the first (pie).

 

[OllyMUK]

You can use the Format Data Point dialog to choose which points are in the second plot (column), and which are in the first (pie).

Thanks Rory, but if I select each one, then I end with each client showing on the Pie chart "Client A High, Client A Low" etc

What I'm after is for the Risk column to show as the pie chart, and the clients with High risk to show as a side Bar, but that doesn't appear to work if you select data point for the Bar manually.

 

[RoryA]

That you can't do. You can't only show the client for the column. The simplest option I can think of would be to plot a separate column chart for just the high risk and place it over the top of the pie.

Edit: I take that back. If you collapse the Medium and Low fields, the chart should look like you want: