Formulas in Chart Titles Axis Titles

[robbbo]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Is there way to have Chart Titles and Axis Titles have formulas that calculate the resultant text?

 

[Mike Middleton]

robbbo -

As far as I know, the appropriate method is to have the formula (that
constructs the text) in a worksheet cell so that the title is a reference to
a single cell.

- Mike
http://www.MikeMiddleton.com


Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Is
there way to have Chart Titles and Axis Titles have formulas that calculate
the resultant text?

 

[Bob Greenblatt]

robbbo -

As far as I know, the appropriate method is to have the formula (that
constructs the text) in a worksheet cell so that the title is a
reference to a single cell.

- Mike
http://www.MikeMiddleton.com


Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel
Is there way to have Chart Titles and Axis Titles have formulas that
calculate the resultant text?

That's one way. another is to enter an = sign int he text box for the
axis title and then click on the cell, or build the formula text
manually. press enter, and the axis text will be constructed.

 

[robbbo]

I cannot get either method to work. What every I type into the title text box is what I see. So if I type in a formula I see the formula including the "=" sign. Is there som sort of setting I need to set?

> > robbbo -
> >
> > As far as I know, the appropriate method is to have the formula (that
> > constructs the text) in a worksheet cell so that the title is a
> > reference to a single cell.
> >
> > - Mike
> > http://www.MikeMiddleton.com
> >
> >
> > wrote in message
> >
> > Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel
> > Is there way to have Chart Titles and Axis Titles have formulas that
> > calculate the resultant text?

> That's one way. another is to enter an = sign int he text box for the
> axis title and then click on the cell, or build the formula text
> manually. press enter, and the axis text will be constructed.
>
> --
>
> Bobgreenblattatmsndotcom
>

 

[CyberTaz]

I'm betting you're typing the expression directly into the chart element
itself, but that isn't the 'text box' that was meant Type the expression
into the Chart Options> Titles text box in the Toolbox/Formatting Palette
[Where it says "Click here to add title"]. I.e., If the cell you want to use
for the content is C15 on SheetX type the expression as:

=SheetX!C15

Then press return. (Don't omit the ! Between the sheet name & the cell
reference.) If you change the content of cell C15 the title will update to
reflect the change.

HTH |:>)
Bob Jones
[MVP] Office:Mac