How to specify pie chart total?

[Guest]

Hi guys,
I'm sure this is me being dim but can you help.
I have a worksheet showing a column of figures that each shows the number of
different 'incidents' that have occurred. At the bottom of the sheet is the
overall number of calls. Many calls do not become an 'incident'. Some calls
can end up with two or more incidents.
I'd like to create a pie chart showing the percentage of each type of
incident - with much of the pie chart blank as many calls did not progress to
becoming an incident. For the life of me I can't work out how to do this. I
can easily create a pie chart that shows the split of percentages within
incidents but I want to show how they all relate to the total calls. Do you
see what I'm getting at?
Hope you can help,
Regards,
Lee

 

[Del Cotter]

I have a worksheet showing a column of figures that each shows the number of
different 'incidents' that have occurred. At the bottom of the sheet is the
overall number of calls. Many calls do not become an 'incident'.

I'd like to create a pie chart showing the percentage of each type of
incident - with much of the pie chart blank as many calls did not progress to
becoming an incident. For the life of me I can't work out how to do this.

You need to define "did not become an incident" as a type of "incident",
and count the number of calls that had that outcome in your column. Now
the total will add up to 100%.

You can format the no incident part of the pie chart to be blank-- no
area and no border.

 

[Guest]

Many thanks Del. I was going to resort to that but wondered if I could
specify the total instead and it would work it all out for me. ;-)