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"
<danielo@discussions.microsoft.com> 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
>>