Chart title variable

  • Thread starter Thread starter Gene Augustin
  • Start date Start date
G

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
 
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
Click to expand...

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.
 
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
 
Back
Top