Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Help -How ?
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 -- conks ------------------------------------------------------------------------ conks's Profile: http://www.excelforum.com/member.php...o&userid=33335 View this thread: http://www.excelforum.com/showthread...hreadid=531655 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart Help -How ?
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 conks wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |