Product: Excel-97 SR2

When creating a chart in Excel, I can easily go right-
click -> Chart Options -> Titles -> Chart Title ->
type: "My really nice chart"

But what if I wanted the chart title to be whatever is in
a cell reference. For example why, can't I...

A1 = "My really nice chart"

right-click -> Chart Options -> Titles -> Chart Title =TEXT
(A1)

In other words, whatever I placed in A1 (assuming it's
text) would appear as the Chart's title, couldn't find
anything in the on-line help file, so hoping someone here
knows how.

- Andrew

If the chart already has a title:
--Click on the chart to select it
--Select the chart title
--Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
--Click on the cell that contains the text for the chart, e.g. C6
--Press the Enter key.

If the chart doesn't have a title:
--Click on the chart to select it
--Type an equal sign -- you'll see it appear in the formula bar
(you don't need to click in the formula bar before typing)
--Click on the cell that contains the text for the chart, e.g. C6
--Press the Enter key.
--Drag the text box from the centre of the chart to the top
--Use the buttons on the formatting toolbar to format the text


Andrew wrote:
> Product: Excel-97 SR2
>
> When creating a chart in Excel, I can easily go right-
> click -> Chart Options -> Titles -> Chart Title ->
> type: "My really nice chart"
>
> But what if I wanted the chart title to be whatever is in
> a cell reference. For example why, can't I...
>
> A1 = "My really nice chart"
>
> right-click -> Chart Options -> Titles -> Chart Title =TEXT
> (A1)
>
> In other words, whatever I placed in A1 (assuming it's
> text) would appear as the Chart's title, couldn't find
> anything in the on-line help file, so hoping someone here
> knows how.
>
> - Andrew


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Excellent! (pardon the pun) I had the right idea, but was
going about it the wrong way, thanks heaps for your help.

- Andrew

>-----Original Message-----
>If the chart already has a title:
> --Click on the chart to select it
> --Select the chart title
> --Type an equal sign -- you'll see it appear in the
formula bar
> (you don't need to click in the formula bar
before typing)
> --Click on the cell that contains the text for the
chart, e.g. C6
> --Press the Enter key.
>
>If the chart doesn't have a title:
> --Click on the chart to select it
> --Type an equal sign -- you'll see it appear in the
formula bar
> (you don't need to click in the formula bar
before typing)
> --Click on the cell that contains the text for the
chart, e.g. C6
> --Press the Enter key.
> --Drag the text box from the centre of the chart to
the top
> --Use the buttons on the formatting toolbar to
format the text
>

You're welcome! And if you need more information on charts, Jon
Peltier's site is a great source:

http://peltiertech.com/Excel/Charts/index.html

Andrew wrote:
> Excellent! (pardon the pun) I had the right idea, but was
> going about it the wrong way, thanks heaps for your help.
>
> - Andrew
>
>
>>-----Original Message-----
>>If the chart already has a title:
>> --Click on the chart to select it
>> --Select the chart title
>> --Type an equal sign -- you'll see it appear in the
>
> formula bar
>
>> (you don't need to click in the formula bar
>
> before typing)
>
>> --Click on the cell that contains the text for the
>
> chart, e.g. C6
>
>> --Press the Enter key.
>>
>>If the chart doesn't have a title:
>> --Click on the chart to select it
>> --Type an equal sign -- you'll see it appear in the
>
> formula bar
>
>> (you don't need to click in the formula bar
>
> before typing)
>
>> --Click on the cell that contains the text for the
>
> chart, e.g. C6
>
>> --Press the Enter key.
>> --Drag the text box from the centre of the chart to
>
> the top
>
>> --Use the buttons on the formatting toolbar to
>
> format the text
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html