Chart title variable

[Gene Augustin]

I have a Horizontal Bar chart. I want the title to be a text variable that
is on the underlying worksheet. Is this possible?

The worksheet cell contains =100*LF & "% LEARNING FACTOR"

That cell has the name "TITLE"

Gene

 

[Rasoul Khoshravan]

I have a Horizontal Bar chart. I want the title to be a text variable that
is on the underlying worksheet. Is this possible?

The worksheet cell contains   =100*LF & "% LEARNING FACTOR"

That cell has the name "TITLE"

Gene

You can enter a title for your chart in step 3 of 4 of chart option,
in Titles tab first box is Chart title.
I don't think it will accept a cell reference.

 

[EricBB]

click the chart title and in the formula bar type =TITLE

 

[Dave Curtis]

Hi,

You can link a chart title to a cell by first giving them any old name via
the chart dialog box. Then click each to get into edit mode, then, in the
formula bar, enter =Sheet1!A1, or whever the text resides. It works with a
named range too, so in your case =Sheet1!Title will work.
You can do the same for the axis titles too.

Dave

 

[Jon Peltier]

You need to prefix the name with the sheet on which it resides:

=Sheet1!TITLE

- Jon