problems editing legend on a pie chart

[tivarney]

I am currently having problems editing the text on a pie chart legend.
It is taking the value that I have and assigning them numbers 1-6.
want to change the numbers in the legend to represent something mor
meaningful such as financials.

Any help would be appreciated!

--Ti

 

[Earl Kiosterud]

Tim,

Do Chart (or right click the chart), Source Data , Series tab. The Category
Labels box should either refer to cells containing your labels, like:

='Sheet1'!$A$2:$A$7
to set this, click in the box, remove anything currently there, then drag
through the cells. It should put the cell reference there.

Or you can put them in right there, like:
={"a","b","c","d","e"}
where a, b, etc., are your names

 

[Jon Peltier]

What's nice, is that you can enter a list like this:

a,b,c,d,e

and Excel will insert the quotes, brackets, and equals sign.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______