I am attempting to create a pie chart with 2 lists of data, in column A I
have a list of occupations and in B I have a recent test scoring. I want a
chart that shows me a comparison of occupation and scores, I have been using
the chart wizard however I am getting a seperate result showing in the chart
for each cell and I need this to show as the scores of each occupation.

I hope this makes sense!