Thread: Pie Charts
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Scott Burke
 
Posts: n/a
Default Pie Charts

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