Title

[Guest]

Hello, is there a way to create a title of a chart in excel by letting it pick it up from a cell (or specifying from whic
cell in the excel sheet to pick up a title)

I am using a statistical package called SAS to throw values into an excel sheet. In the excel sheet, I a
creating a table. I want to be able to create a title of the chart by just throwing a value from SAS to Excel
But to do this I need to know how I can let the table know where to pick up a title from

Thanks in advance

Kaz

 

[Paul B]

Kaz, click on the chart title and put = in the formula bar then click on the
cell you want to use and enter

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Hello, is there a way to create a title of a chart in excel by letting it

pick it up from a cell (or specifying from which

cell in the excel sheet to pick up a title)?

I am using a statistical package called SAS to throw values into an excel

sheet. In the excel sheet, I am

creating a table. I want to be able to create a title of the chart by

just throwing a value from SAS to Excel.

 

[Frank Kabel]

Hi
try the following:
- select the title text box
- now click in the formula bar
- enter your formula. e.f.
='Sheet1'!A1

Note: Enter this formula directly in the formula bar, NOT in the text
box

 

[Debra Dalgleish]

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