Pie Chart - "Other" Slice

[WaY]

Hi,

I work for a Diagnostic Center and we have a spreadsheet of the numbe
of
referrals recieved from each doctor for each month, and I am trying t
make a
pie chart showing the percentage of referrals from each doctor
However, there
are about 85 doctors who referred to our facility last month, but man
of them
only referred 1-2 patients, which is less than 1% of our tota
business. What I
want to do is make the pie chart show an individual slice for those wh
referred
more than say, 5 patients, and all those who referred less show under
single
slice labelled "OTHER".

Also, I need help getting the slices to show a label other than "1"
"2", "3"
etc. The spreadsheet is set up like so:


Code
-------------------

[Doctors] MRI U/S X-Ray CT Total
Dr. xxx x x x x x
Dr. zzz x x x x x
Dr. yyy x x x x x
Dr. aaa x x x x x
Total x x x x x

 

[Guest]

Have a look at http://www.allaboutoffice.co.uk/exchtpie.htm for how to make a
bar-of-pie chart.

Andrea Jones
http://www.allaboutoffice.co.uk
http://www.stratatraining.co.uk
http://www.allaboutclait.com

 

[WaY]

I can't believe I missed that.

Thanks