Chart Help

  • Thread starter Thread starter Teeny
  • Start date Start date
T

Teeny

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!
 
Before you create the pie chart select both the A row (occupations) and the B
row (test scores). When creating make sure columns is checked under data
range. Under data labels check info you want to appear on the pie chart.
Category name and percent would work well for your comparison.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help on Exit Calcs 5
Excel Can a pie of pie chart use animation/transitions? 1
Excel Charts 1
Statistics on data 3
Show Total In a Text Box in a Pie Chart 2
Dependant lists using Combo Boxes 2
Pivot Table 1
Retrieve Information based on Condition 2

Back
Top