Hi Scott,
As Tushar points out your pie chart must contain 2 values.
For easy of chart creation use the following cell values.
M1: =500
M4: =100
M5: =M1-M4
Select the range M4:M5 and use the chart wizard to create a 2 slice pie
chart. Click the pie and then click the second slice. Press CRTL+1 to
bring up the Format Data Point dialog. Set the Area and Border colours
to None. This will leave you a slice 1/5th of the pie.
Cheers
Andy
Scott Burke wrote:
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
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info