Bar of Pie Chart issue.

[ECO-Lo]

Hi,

I have been to other threads and looked at tons of websites featuring info on bar of pie. But I am having difficulty getting mine to show the information in a specific way.

I am trying to get the pie to show total fuel and fuel consumed, with the bar of pie showing that total fuel is made up of fuel received and fuel delivered. My data is set up as such:

A6: Total Fuel E6: 1628098
A7: Fuel Received E7: 1046760
A8: Fuel Delivered E8: 581338
A9: Fuel Consumed E9: 312466

Can someone please help me?

[adhawan06]

Hi ECO-lo

I have attached a workbook for your reference. please refer the same.

I just changed the position of Fuel Consumed from A9 to A7 and it worked perfectly fine.

Chart Answers.png

[Andy Pope]

You don't need the data point that is the combination of bar items, that slice is automatically created.

[adhawan06]

Ignore my answer....Thanks Andy for correcting me...

[ECO-Lo]

Thank you! That's exactly what I needed.

[adhawan06]

Hi Eco,

Glad it worked for you.

Don't forget to take few seconds to marked this thread as SOLVED and say Thanks to the people by adding *Add Reputation