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

Re: MS Excel 2007 - lables in charts by Beth

Beth
Mon Aug 04 12:34:51 PDT 2008

"Keith" <Keith@discussions.microsoft.com> wrote in message
news:0EAD6E67-F443-4392-AF2B-6319A31850CE@microsoft.com...
> 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.

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



Re: MS Excel 2007 - lables in charts by Keith

Keith
Tue Aug 05 08:43:01 PDT 2008

Many Thanks Meth.

That was really very helpful.

Thanks

"Beth Melton" wrote:

> "Keith" <Keith@discussions.microsoft.com> wrote in message
> news:0EAD6E67-F443-4392-AF2B-6319A31850CE@microsoft.com...
> > 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.
>
> 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
>
>
>

Re: MS Excel 2007 - lables in charts by Beth

Beth
Tue Aug 05 09:13:05 PDT 2008

You're welcome! :-)

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

"Keith" <Keith@discussions.microsoft.com> wrote in message
news:C43AFBE1-78A8-438A-AE10-01C203B0D2C6@microsoft.com...
> Many Thanks Meth.
>
> That was really very helpful.
>
> Thanks
>
> "Beth Melton" wrote:
>
>> "Keith" <Keith@discussions.microsoft.com> wrote in message
>> news:0EAD6E67-F443-4392-AF2B-6319A31850CE@microsoft.com...
>> > 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.
>>
>> 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.