Pivot Table help

[gjrscotland]

Hi Everyone,

I have an issue with pivot tables i hope you can help with.

I have a pivot table which displays the complaints per month for L, ST, SY & Overall.
What i need to do is turn this into a line graph of complaints per million strips sold.
Can anyone advise a way of doing this within the table please.
Any help is greatly appreciated.

Thanks!

[dilipandey]

Hi gjrscotland,

You can create pivot chart using your pivot table where L,ST,SY etc will come on X-axis and their count would be plotted against y-axis values.

Try this and if you stuck, upload the sample workbook.. thanks.


Regards,
DILIPandey
<click on below * if this helps>