Donut Chart

Hi Mark Jackson ,

First of all great graphic! Its awesome!

I was just wondering if you had any suggestions how to modify it, I've been trying to do it but can't.

I have 2 sets of data:

1. Actual 2016 and 2015 figures
2. Projection/budget percentages for 2016

In my data I use 2 simple formula to calculate the budget vs actual

1. 2016 Budget = Sum(2015)*(Budget%+1)
2. 2016 actual data = (if year =2016 then total volume else 0 end) (2015 works exactly the same)

it works perfectly in a bar graph but I can't convert it into a pie chart because I can't get any color/field distinctions. I couldn't use the set idea you used because of the formulas and different data sets, wouldn't let me create one.

Any suggestions on how I can split the colors so I can use your graphic?