MS Excel 2007 - lables in charts

K

Keith

Hi,

Can any one help me on the follwoing:

How to add 1) Series name to an axes 2) Category name assigned to all data
points 3) name/label to X and Y axis.

The chart type I am using has two Y axis - primary and secondary.

Many thanks in advance.

Regards
 
B

Beth Melton

Keith said:
Hi,

Can any one help me on the follwoing:

How to add 1) Series name to an axes 2) Category name assigned to all data
points 3) name/label to X and Y axis.

The chart type I am using has two Y axis - primary and secondary.

Many thanks in advance.
Click to expand...

For #1: On the contextual Chart Tools, click the Layout tab and you'll find
the Axes Titles in the Labels group. For #2: Also in the Labels group. Click
Data Labels and then click More Data Label Options. You'll find the Category
in the Label Options. For #3, I'm not exactly sure what you are asking but
if you look around the Format dialog box (right-click a chart element and
then click the Format command at the bottom) you might find what you are
looking for. Note that you can leave the Format dialog box open and click
other Chart elements to change to their options.

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx
 
Top