Pareto Graph issue

[Emmily]

Hi,

I am trying to create a Pareto chart for the below data, i am having trouble showing the percentage as a line the legend shows there is percentage and volume but on the graph I cannot see the % data.

Any ideas what could be wrong here?

[TABLE="width: 309"]
<col style="width: 74pt;" width="98"> <col style="width: 38pt;" width="51"> <col style="width: 108pt;" width="144"> <col style="width: 89pt;" width="119"> <tbody>[TR]
[TD="class: xl24, width: 98"]Team[/TD]
[TD="class: xl24, width: 51"]Volume[/TD]
[TD="class: xl24, width: 144"]Cumulative Frequencey[/TD]
[TD="class: xl24, width: 119"]Percentage[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test1[/TD]
[TD="class: xl24"]6015[/TD]
[TD="class: xl24"]6015[/TD]
[TD="class: xl25"]51.91%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test2[/TD]
[TD="class: xl24"]245[/TD]
[TD="class: xl24"]6260[/TD]
[TD="class: xl25"]54.02%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test3[/TD]
[TD="class: xl24"]4[/TD]
[TD="class: xl24"]6264[/TD]
[TD="class: xl25"]54.06%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test4[/TD]
[TD="class: xl24"]1[/TD]
[TD="class: xl24"]6265[/TD]
[TD="class: xl25"]54.06%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test5[/TD]
[TD="class: xl24"]22[/TD]
[TD="class: xl24"]6287[/TD]
[TD="class: xl25"]54.25%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test6[/TD]
[TD="class: xl24"]21[/TD]
[TD="class: xl24"]6308[/TD]
[TD="class: xl25"]54.44%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test7[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]6311[/TD]
[TD="class: xl25"]54.46%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test8[/TD]
[TD="class: xl24"]55[/TD]
[TD="class: xl24"]6366[/TD]
[TD="class: xl25"]54.94%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test9[/TD]
[TD="class: xl24"]126[/TD]
[TD="class: xl24"]6492[/TD]
[TD="class: xl25"]56.02%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test10[/TD]
[TD="class: xl24"]90[/TD]
[TD="class: xl24"]6582[/TD]
[TD="class: xl25"]56.80%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test11[/TD]
[TD="class: xl24"]76[/TD]
[TD="class: xl24"]6658[/TD]
[TD="class: xl25"]57.46%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test12[/TD]
[TD="class: xl24"]7[/TD]
[TD="class: xl24"]6665[/TD]
[TD="class: xl25"]57.52%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test13[/TD]
[TD="class: xl24"]131[/TD]
[TD="class: xl24"]6796[/TD]
[TD="class: xl25"]58.65%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test14[/TD]
[TD="class: xl24"]1531[/TD]
[TD="class: xl24"]8327[/TD]
[TD="class: xl25"]71.86%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test15[/TD]
[TD="class: xl24"]110[/TD]
[TD="class: xl24"]8437[/TD]
[TD="class: xl25"]72.81%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test16[/TD]
[TD="class: xl24"]193[/TD]
[TD="class: xl24"]8630[/TD]
[TD="class: xl25"]74.47%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test17[/TD]
[TD="class: xl24"]29[/TD]
[TD="class: xl24"]8659[/TD]
[TD="class: xl25"]74.72%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test18[/TD]
[TD="class: xl24"]125[/TD]
[TD="class: xl24"]8784[/TD]
[TD="class: xl25"]75.80%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test19[/TD]
[TD="class: xl24"]30[/TD]
[TD="class: xl24"]8814[/TD]
[TD="class: xl25"]76.06%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test20[/TD]
[TD="class: xl24"]208[/TD]
[TD="class: xl24"]9022[/TD]
[TD="class: xl25"]77.86%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test21[/TD]
[TD="class: xl24"]163[/TD]
[TD="class: xl24"]9185[/TD]
[TD="class: xl25"]79.26%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test22[/TD]
[TD="class: xl24"]721[/TD]
[TD="class: xl24"]9906[/TD]
[TD="class: xl25"]85.48%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test23[/TD]
[TD="class: xl24"]46[/TD]
[TD="class: xl24"]9952[/TD]
[TD="class: xl25"]85.88%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test24[/TD]
[TD="class: xl24"]459[/TD]
[TD="class: xl24"]10411[/TD]
[TD="class: xl25"]89.84%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test25[/TD]
[TD="class: xl24"]14[/TD]
[TD="class: xl24"]10425[/TD]
[TD="class: xl25"]89.96%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test26[/TD]
[TD="class: xl24"]75[/TD]
[TD="class: xl24"]10500[/TD]
[TD="class: xl25"]90.61%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test27[/TD]
[TD="class: xl24"]3[/TD]
[TD="class: xl24"]10503[/TD]
[TD="class: xl25"]90.64%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test28[/TD]
[TD="class: xl24"]28[/TD]
[TD="class: xl24"]10531[/TD]
[TD="class: xl25"]90.88%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test29[/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]10536[/TD]
[TD="class: xl25"]90.92%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test30[/TD]
[TD="class: xl24"]105[/TD]
[TD="class: xl24"]10641[/TD]
[TD="class: xl25"]91.83%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test31[/TD]
[TD="class: xl24"]93[/TD]
[TD="class: xl24"]10734[/TD]
[TD="class: xl25"]92.63%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test32[/TD]
[TD="class: xl24"]8[/TD]
[TD="class: xl24"]10742[/TD]
[TD="class: xl25"]92.70%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test33[/TD]
[TD="class: xl24"]303[/TD]
[TD="class: xl24"]11045[/TD]
[TD="class: xl25"]95.31%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test34[/TD]
[TD="class: xl24"]62[/TD]
[TD="class: xl24"]11107[/TD]
[TD="class: xl25"]95.85%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test35[/TD]
[TD="class: xl24"]302[/TD]
[TD="class: xl24"]11409[/TD]
[TD="class: xl25"]98.46%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test36[/TD]
[TD="class: xl24"]103[/TD]
[TD="class: xl24"]11512[/TD]
[TD="class: xl25"]99.34%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test37[/TD]
[TD="class: xl24"]12[/TD]
[TD="class: xl24"]11524[/TD]
[TD="class: xl25"]99.45%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test38[/TD]
[TD="class: xl24"]21[/TD]
[TD="class: xl24"]11545[/TD]
[TD="class: xl25"]99.63%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test39[/TD]
[TD="class: xl24"]6[/TD]
[TD="class: xl24"]11551[/TD]
[TD="class: xl25"]99.68%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test40[/TD]
[TD="class: xl24"]9[/TD]
[TD="class: xl24"]11560[/TD]
[TD="class: xl25"]99.76%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test41[/TD]
[TD="class: xl24"]6[/TD]
[TD="class: xl24"]11566[/TD]
[TD="class: xl25"]99.81%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test42[/TD]
[TD="class: xl24"]13[/TD]
[TD="class: xl24"]11579[/TD]
[TD="class: xl25"]99.92%[/TD]
[/TR]
[TR]
[TD="class: xl24"]Test43[/TD]
[TD="class: xl24"]9[/TD]
[TD="class: xl24"]11588[/TD]
[TD="class: xl25"]100.00%[/TD]
[/TR]
</tbody>[/TABLE]

 

[paddydive]

Hi Emmily,

That may be because your volume and percentage both are on same axis (primary)
Try to change axis of one of it to secondary axis and you can view it on chart

you have to right click on one legend a click format data-series and select Secondary Axis in plot series on section

 

[Emmily]

Hi,

I have followed the steps shown in this link, i still cannot see percentage. Please have a try and see what results you get.

How to Create a Pareto Chart in MS Excel 2010: 14 Steps

 

[paddydive]

Hi,

In such case I used a shortcut.

1) Instead of column chart use line chart (this will make both the series visible)
2) Select Percentage Series and changes its Axis type to Secondary Axis ( as shown in your above link)
3) select Volume series and changes its chart type to column

Try this it works for me most of the time.