Sales Pivot Chart

[SmiteshN]

I wanna present Sales achieved against the Target for each Salesman & show the percentage achieved. When i try to present it on pivot chart i am not able to get the correct percentage on Bar graph

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]SalesMan[/TD]
[TD="width: 64"]Sales[/TD]
[TD="width: 64"]Target[/TD]
[/TR]
[TR]
[TD]Santner[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD]Turkish[/TD]
[TD="align: right"]3200[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD]Billy[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD]Mccullum[/TD]
[TD="align: right"]700[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD]Johana[/TD]
[TD="align: right"]1600[/TD]
[TD="align: right"]4000[/TD]
[/TR]
[TR]
[TD]Janice[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]6000[/TD]
[/TR]
[TR]
[TD]Amy[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4000[/TD]
[/TR]
</tbody>[/TABLE]

 

[Oeldere]

Maybe like this (pivot table does not show correct, when using HTLM code)

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	SalesMan	Sales	Target	%			Rijlabels	%	Sales	Target	View Sales
2	Santner	3500	6000	58,33%			Amy	0,00%	0	4.000
3	Turkish	3200	6000	53,33%			Billy	37,50%	1.500	4.000
4	Billy	1500	4000	37,50%			Janice	8,33%	500	6.000
5	Mccullum	700	6000	11,67%			Johana	40,00%	1.600	4.000
6	Johana	1600	4000	40,00%			Mccullum	11,67%	700	6.000
7	Janice	500	6000	8,33%			Santner	58,33%	3.500	6.000
8	Amy	0	4000	0,00%			Turkish	53,33%	3.200	6.000
Blad1