Pie chart labels (Office 2007)
 

I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can you
advise.

Pie chart labels (Office 2007)
 

Using XL2003 or earlier? Then in Step 3 of Chart Wizard open Label tab and
check the two boxes Category and Value (or Category and Percent, as needed)
Then remove legend
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"E" wrote in message
...
I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can
you
advise.

Pie chart labels (Office 2007)
 

No, I'm in Office 2007 so there is no Wizard.

"Bernard Liengme" wrote:

Using XL2003 or earlier? Then in Step 3 of Chart Wizard open Label tab and
check the two boxes Category and Value (or Category and Percent, as needed)
Then remove legend
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"E" wrote in message
...
I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can
you
advise.

Pie chart labels (Office 2007)
 

Select chart; you will see a Chart Tools tab on the title bar
Open the Layout tab; look in the Labels group where you will see Data
Labels; open this
Open the last item "More Data Labels Options"
Check the two boxes as required
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"E" wrote in message
...
No, I'm in Office 2007 so there is no Wizard.

"Bernard Liengme" wrote:

Using XL2003 or earlier? Then in Step 3 of Chart Wizard open Label tab
and
check the two boxes Category and Value (or Category and Percent, as
needed)
Then remove legend
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"E" wrote in message
...
I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can
you
advise.

Pie chart labels (Office 2007)
 

Fantastic! Somehow I missed that. Thank you very much.

"Bernard Liengme" wrote:

Select chart; you will see a Chart Tools tab on the title bar
Open the Layout tab; look in the Labels group where you will see Data
Labels; open this
Open the last item "More Data Labels Options"
Check the two boxes as required
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"E" wrote in message
...
No, I'm in Office 2007 so there is no Wizard.

"Bernard Liengme" wrote:

Using XL2003 or earlier? Then in Step 3 of Chart Wizard open Label tab
and
check the two boxes Category and Value (or Category and Percent, as
needed)
Then remove legend
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"E" wrote in message
...
I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can
you
advise.

Pie chart labels (Office 2007)
 

Hi,

In 2007 we are all going to want to start using the right mouse button more
because most of these context menus have been highly enhanced. For example,
you can do what you want by right clicking the pie and choosing Add Data
Labels. You can modify them also with one step - right click any data label
and choose Format Data Labels.

Its a good thing they added these and many other commands to the right-mouse
button, because they took double-clicking away. What were they thinking?
--
Thanks,
Shane Devenshire


"E" wrote:

I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can you
advise.

Pie chart labels (Office 2007)
 

Hi Shane
Long ago I started to use right clicking for many tasks, so 2007 is fine
with me.
For some reason I have stopped telling about right click when answering
here - thanks for the reminder
--
Bernard

"ShaneDevenshire" wrote in
message ...
Hi,

In 2007 we are all going to want to start using the right mouse button
more
because most of these context menus have been highly enhanced. For
example,
you can do what you want by right clicking the pie and choosing Add Data
Labels. You can modify them also with one step - right click any data
label
and choose Format Data Labels.

Its a good thing they added these and many other commands to the
right-mouse
button, because they took double-clicking away. What were they thinking?
--
Thanks,
Shane Devenshire


"E" wrote:

I want to add labels to my segments along side the pie, rather than as a
legend at the side, eg, Category A £100, Category B £50 etc. Please can
you
advise.