I have a chart that I've created. The X-axis lables look like this:

29 6 13 20 27
October

I would like to put an average underneath "October." I have a row that
calculates averages for each month. I have been able to go in and manually
add a hard return to my "October" title so that it shows up like this:

October
(4.2)

I created the following formula to have that average automate itself, so I
don't have to manually change the averages of the data for each month. The
formula looks like this (my average is in cell D2).

="October"&"("D2&")

However, this shows up like this:

October(4.2)

How do I write the formula to add a hard return so that the "4.2" is
centered underneath the "October"?

Thank you!

Alignment depends on the alignment of the text element. The line feed uses
CHAR(10):

="October"&CHAR(10)&"("&D2&")"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Judi" wrote in message
...
I have a chart that I've created. The X-axis lables look like this:

29 6 13 20 27
October

I would like to put an average underneath "October." I have a row that
calculates averages for each month. I have been able to go in and
manually
add a hard return to my "October" title so that it shows up like this:

October
(4.2)

I created the following formula to have that average automate itself, so I
don't have to manually change the averages of the data for each month.
The
formula looks like this (my average is in cell D2).

="October"&"("D2&")

However, this shows up like this:

October(4.2)

How do I write the formula to add a hard return so that the "4.2" is
centered underneath the "October"?

Thank you!

Thank you so much, once again! You did the trick! Now to figuring out how
to add a footer to a chart ~ and do it on all charts at the same time (when
all the charts are on different spreadsheets :/ ).

"Jon Peltier" wrote:

Alignment depends on the alignment of the text element. The line feed uses
CHAR(10):

="October"&CHAR(10)&"("&D2&")"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Judi" wrote in message
...
I have a chart that I've created. The X-axis lables look like this:

29 6 13 20 27
October

I would like to put an average underneath "October." I have a row that
calculates averages for each month. I have been able to go in and
manually
add a hard return to my "October" title so that it shows up like this:

October
(4.2)

I created the following formula to have that average automate itself, so I
don't have to manually change the averages of the data for each month.
The
formula looks like this (my average is in cell D2).

="October"&"("D2&")

However, this shows up like this:

October(4.2)

How do I write the formula to add a hard return so that the "4.2" is
centered underneath the "October"?

Thank you!