combine "category labels" & "values" in legend
 

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....

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.


On Mon, 7 Feb 2005 13:51:02 -0800, "danielo"
wrote:

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....

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

danielo wrote:
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....

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

"Andy Pope" wrote:

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

danielo wrote:
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....

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Didn't Andy just give you the workaround?

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

danielo wrote:

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

"Andy Pope" wrote:


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

danielo wrote:

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....

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info