a Slice in two colors

[Qaseem]

I have the following data in a table

A $40,000
B $89,000 (70% spent)
C $63,000
D $74,000

I want to show that 70% of slice B has been spent. Can I show that in
the same pie chart by having slice B in two shades of the same color
based on the PCT.

Thanks

 

[Andy Pope]

Hi Qaseem,

You will need to modify your data and add another value between B and C
and format the slices to suit.

A $40,000
B =$89,000*.7 (70% spent)
b =$89,000*.3 (30% Unspent)
C $63,000
D $74,000

The Pie in Pie with conditional format on my site may help.
(http://www.andypope.info/charts/pies.htm)