Displaying a deduction pie chart.

M

McM

This one should be simple. I need to create a chart that shows the balance of a check book. The trouble that I am having now is that the amount is split in half equally.

Example: The entire chart shows that there is 1000 in the bank. When you withdrawel 999, the chart should show all but one dollar of the chart used up.
 
T

Tushar Mehta

If the total is in E10 and the withdrawal is in D11, then in E11 enter
the formula =E10-D11

Select D11:E11 and create a pie chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pie Chart with automatic "All Other" group 1
How to create a complicated pie chart 0
How to credit complicated pie chart 0
Pie Chart displayed on top of a Pie Chart 7
Aggregating Data in Other Category on Pie Chart 2
Edit Pie Chart Data Label 0
Pie chart problem 2
Percentages in a pie chart 3

Top