Thanks Tushar and Andy.
Andy, I will give this a try tonight.

Scott


"Andy Pope" wrote:

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