Chart title

Hello everybody. How to name the chart (title) with the value in a cell. say
B1.
Thanks to you all
With regards
Sridhar

Select the chart title, click in the formula bar, & type = then click in B1,
& accept the formula.
--
David Biddulph

"yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
news:39D32BA9-7109-4ED2-8F83-E9CE99D3501A@microsoft.com...
> Hello everybody. How to name the chart (title) with the value in a cell.
> say
> B1.
> Thanks to you all
> With regards
> Sridhar

Sorry Mr. David. I could not follow you. Chart|chart options|title|chart
title . I could not place the formula in this. May be i am misunderstood
you. If i type the =b1 inthis it is displaying the same ie, = b1 in the
title.
With regards
Sridhar

"David Biddulph" wrote:

> Select the chart title, click in the formula bar, & type = then click in B1,
> & accept the formula.
> --
> David Biddulph
>
> "yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
> news:39D32BA9-7109-4ED2-8F83-E9CE99D3501A@microsoft.com...
> > Hello everybody. How to name the chart (title) with the value in a cell.
> > say
> > B1.
> > Thanks to you all
> > With regards
> > Sridhar
>
>
>

Hi,

You need to add a chart title, any text will do. Once you have a chart title
you can then link it to a cell by doing the following.
Select the chart title
In the formula bar enter the cell reference, =B1

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
news:6215353A-41A2-47A3-B2C0-0521A40E6B56@microsoft.com...
> Sorry Mr. David. I could not follow you. Chart|chart options|title|chart
> title . I could not place the formula in this. May be i am misunderstood
> you. If i type the =b1 inthis it is displaying the same ie, = b1 in the
> title.
> With regards
> Sridhar
>
> "David Biddulph" wrote:
>
>> Select the chart title, click in the formula bar, & type = then click in
>> B1,
>> & accept the formula.
>> --
>> David Biddulph
>>
>> "yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
>> news:39D32BA9-7109-4ED2-8F83-E9CE99D3501A@microsoft.com...
>> > Hello everybody. How to name the chart (title) with the value in a
>> > cell.
>> > say
>> > B1.
>> > Thanks to you all
>> > With regards
>> > Sridhar
>>
>>
>>

Thank you Andy. It worked but =sheet!B1 did it.
With regards
Sridhar

"Andy Pope" wrote:

> Hi,
>
> You need to add a chart title, any text will do. Once you have a chart title
> you can then link it to a cell by doing the following.
> Select the chart title
> In the formula bar enter the cell reference, =B1
>
> Cheers
> Andy
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
> "yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
> news:6215353A-41A2-47A3-B2C0-0521A40E6B56@microsoft.com...
> > Sorry Mr. David. I could not follow you. Chart|chart options|title|chart
> > title . I could not place the formula in this. May be i am misunderstood
> > you. If i type the =b1 inthis it is displaying the same ie, = b1 in the
> > title.
> > With regards
> > Sridhar
> >
> > "David Biddulph" wrote:
> >
> >> Select the chart title, click in the formula bar, & type = then click in
> >> B1,
> >> & accept the formula.
> >> --
> >> David Biddulph
> >>
> >> "yshridhar" <yshridhar@discussions.microsoft.com> wrote in message
> >> news:39D32BA9-7109-4ED2-8F83-E9CE99D3501A@microsoft.com...
> >> > Hello everybody. How to name the chart (title) with the value in a
> >> > cell.
> >> > say
> >> > B1.
> >> > Thanks to you all
> >> > With regards
> >> > Sridhar
> >>
> >>
> >>
>