Can't get pie chart to use correct data

[IanGlinka]

I have data organized after a subtotal in the following format:

All I want to do is create a pie chart that has data labels A, C, E, F, L, M, P, R, X

If I select just the numbers as the datasource, it creates an accurate pie chart, but with data generic data labels like "1, 2, 3..." or "A, B, C..."

If I select the entire block, it doesn't seem to be figuring out that I want the numbers (Column F) to be used as the data, and the label in the cell directly left of the number (Column E) to be used as the data labels.

Anyone know a way to do this?

Thanks
Ian

 

[lhite]

What I would do is select the data that you want, choose EDIT, GOTO, SPECIAL, VISIBLE CELLS ONLY, then COPY the data and paste it below the data or on another sheet. Create your chart off of that.

-Larry

 

[xlhelp]

You could just plot the Pie chart, then right click on the chart, choose Source Data. Go to the Series Tab. Delete whatever is in the box beside Name: Click the icon in the box beside Values: and highlight the values in column F. Click the icon in the box beside Category Labels: and highlight names in column E.