Hi Tushar. Thank you for your time. Maybe I did not explain what I was
after.
Let me try again.
1) I wont the hole pie to equal "M1". example M1 = 500
I wont the hole pie to equal 500
2) I wont the slice of pie to equal "M4". example M4 = 100
I wont only ONE (1) slice in the pie. That slice should equal = 100 or
1/5 of the pie.
how do I assign the whole pie a value????
Scott Burke
"Tushar Mehta" wrote:
In some cell, say M5, enter =M1-M4.
Plot M4:M5. The first slice will be M4. The 2nd slice will represent the
savings for the month. The total pie, of course, will represent the money
made in the month.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I am trying to use a pie chart. What I wont to do is this.
Cell M1 = How much money I made this month.
Cell M4 = How much I wrote in checks.
I wont the pie chart to show "M1" that is the pie it self = "M1"
and I wont the pie slice (one slice) to show "M4"
I cant seem to get the pie chart to equal "M1". "M1" allways shows up as a
slice it self.
Can it be done?
Scott Burke