Chart Help -How ?

  • Thread starter Thread starter conks
  • Start date Start date
C

conks

Hi,

I'm a newbie with Excel & I am struggling to make this work.

It's work related.

I'm simply trying to show sales figures in a Pie-chart based upon the
following information:

Alex Frankie w/c 13/3/06
Calls made 45 70
No. not interested 10 10
No. interested 1 8
No. of call backs 34 52
Appointments made 0 1

But I can't work out how I'm going to show the legends but also
including the 2 staff members.

I'm sure somebody out there will have a better resolution.

Thanks
 
Hi,

Have a look at the pie in pie example. The legend will convert to the 2
series labels. The colour of the legend marker reflects the colour of
the first segments.

Maybe consider an alternative chart style. If you want a round chart try
the donut.
Personally I would go with a column chart so you can see the comparative
score more easily.

Cheers
Andy

http://www.andypope.info/charts/pies.htm
 
Back
Top