How To Edit Pie Chart Legend Labels?

[leu]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

Once I create a pie chart, how do I change the legend labels 1,2,3, etc. to something descriptive?

 

[staticemi]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

Once I create a pie chart, how do I change the legend labels 1,2,3, etc. to something descriptive?

Did you ever figure this out? I have the same issue.

 

[leu]

> Version: 2008
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: intel
>
> Once I create a pie chart, how do I change the legend labels 1,2,3, etc. to something descriptive?

Did you ever figure this out? I have the same issue.

Not yet. Apparently not too many power users read these question forums, just newbies like us. I have the O'Reilly book on order which will hopefully explain this common function. When I solve it I will post the answer.

 

[June Low [MSFT]]

Hi leu

When you insert your pie chart, is it just with one column of data? I find
that if I have one column (A) of labels and a second column (B) of labels
and I select both and create a pie chart that way, it uses column A for the
legend labels and column B for the data.

I hope this helps. If not, please let me know a little more about the data
you're trying to plot and I'll try to help.

- June
OfficeArt Tester, MacBU
Microsoft

 

[leu]

Hi leu

When you insert your pie chart, is it just with one column of data? I find
that if I have one column (A) of labels and a second column (B) of labels
and I select both and create a pie chart that way, it uses column A for the
legend labels and column B for the data.

I hope this helps. If not, please let me know a little more about the data
you're trying to plot and I'll try to help.

- June
OfficeArt Tester, MacBU
Microsoft

Hello June,

Thanks for the helpful response. My spreadsheet is more complicated. It is one that grows columns to the right-hand side over time. The data is separated from the labels in the first column and only certain data values in the columns(totals) are used in the pie chart, not the whole column(for instance M5, M10, M15).

Your suggestion led me to try another way of creating the chart that works: Insert Chart, select the label cell on the spreadsheet, select the data cell it corresponds to, repeat for each instance of label/data and then select the pie chart control from the elements gallery to create it.

The concept I was missing is that the pie chart labels must be tied to a label on the spreadsheet.

Thanks again.

Leu