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!