Hi,
I'm a newbie with Excel amp; 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:
AlexFrankiew/c 13/3/06
Calls made 4570
No. not interested 1010
No. interested 18
No. of call backs 3452
Appointments made 01
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--
conks
------------------------------------------------------------------------
conks's Profile: www.excelforum.com/member.php...oamp;userid=33335
View this thread: www.excelforum.com/showthread...hreadid=531655Hi,
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
www.andypope.info/charts/pies.htm
conks wrote:
gt; Hi,
gt;
gt; I'm a newbie with Excel amp; I am struggling to make this work.
gt;
gt; It's work related.
gt;
gt; I'm simply trying to show sales figures in a Pie-chart based upon the
gt; following information:
gt;
gt; AlexFrankiew/c 13/3/06
gt; Calls made 4570
gt; No. not interested 1010
gt; No. interested 18
gt; No. of call backs 3452
gt; Appointments made 01
gt;
gt; But I can't work out how I'm going to show the legends but also
gt; including the 2 staff members.
gt;
gt; I'm sure somebody out there will have a better resolution.
gt;
gt; Thanks
gt;
gt;
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
- Dec 25 Tue 2007 20:41
Chart Help -How ?
close
全站熱搜
留言列表
發表留言