Chart style needed to meet certain requirements

Hi everyone, just a quick question that I have, won't take too much of your time.

I want to have a chart (was hoping for a pie chart, but couldn't figure out how to work it) where I can use one value as the "total" (taken from a specific cell) and have other values (from other cells) inserted to form up the composition of this "total" value, with the difference between the overall total and the additions being displayed as an excess.

Eg: (If I could do this in a pie-chart) I would need:
1. Total value of pie displayed
2. Pieces of the pie represent various cells with specific values in them
3.
The remaining pie will form the last "slice" which will get smaller if values in 2. increase and larger if values in 2. decrease.
4. I want the divisions to represent (at least by the size of the slice) the percentage that each particular slice comprises out of the whole (ie: a slice worth R70 would be shown a "10%" on a graph with a total value of R700)


Also if the total changes then obviously the entire pie size should change. These are my goals, I don't know which chart to use though. If it helps this is for a personal budget, with total income being the size of the pie and various expenses comprising the slices that eat away at the overall pie, with the remaining "last slice" comprising the remaining cash I have remaining (after expenses).

If anyone knows how to help please feel free, i will take any explanation (no matter the length), but these are my goals, can they be done in Excel?

Thanks in advance for any assistance.

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

Thanks, please lock, my error.

Thanks for taking the time to read and comply with the rule .

OP posted in chart forum