Chart title variable
 

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

Chart title variable
 

On Feb 18, 9:07*am, Gene Augustin
wrote:
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.

Chart title variable
 

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

"Gene Augustin" wrote:

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

Chart title variable
 

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

"Rasoul Khoshravan" wrote:

On Feb 18, 9:07 am, Gene Augustin
wrote:
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.

Chart title variable
 

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

=Sheet1!TITLE

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"EricBB" wrote in message
...
click the chart title and in the formula bar type =TITLE

"Gene Augustin" wrote:

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