combine "category labels" & "values" in legend

[Guest]

I'm creating a pie chart, and in the legend I want not JUST the "category
labels," but both them AND the associated "values." Can't find any Legend
formatting except font/pattern/color etc....

 

[Myrna Larson]

I think this may be an option with your data labels, but not with the legend
itself. If you can't find it under Format/Legend, it can't be done.

 

[Andy Pope]

Hi,

You can't do this directly through any properties of the legend.
You can create the required text in a cell and then specify this as the
series name. The series name is what is displayed in the legend.

Cheers
Andy

 

[Guest]

Well, thanks for the feedback. I'll find a work-around. That would be a
useful feature, methinks!

 

[Jon Peltier]

Didn't Andy just give you the workaround?

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