pie chart legend text

M

MacCoon

My pie chart has 10 data values (e.g. 10 sectors). The
legend shows a little box with the color that coordinates
with each sector and they are automatically numbered 1
thru 10.
I have the data in a column and the respective text in an
adjacent column.
I want the legend text to come from the spreadsheet. Right
now, I get numbers 1 thru 10 next to the little box and I
cannot seem to change the text.

Maybe I have the data set up wrong? Should it be
something other than columns?

Tnx in advance for any help
Brian
(e-mail address removed)
 
J

Jon Peltier

Brian -

A little work up front saves trouble later. Put the labels in the
column immediately to the left of the data. Select both columns of
data, then make your chart. Excel uses the labels in the legend.

But you don't want to make all your charts over. And maybe the data
isn't arranged exactly the way I described. So select the chart, and
choose Source Data from the Chart menu. Click on the Series tab, click
in the (presumably blank) Category Labels box, and with your mouse
select the range containing the text labels.

You can do this with your data in rows, too. Put the labels immediately
above the values.

- Jon
 
B

Brian coon

Placing the text in the left side adjacent column gave me
exactly what I wanted . Tnx

Brian
 

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

Top