http://www.excelforum.com/excel-new-...07#post2499307

Hi!

This is a follow-up from a previous thread regarding axis labelling. The problem is that long axis labels stays on one line, instead of splitting into two or three lines. The solution proposed when having trouble is using ALT+ENTER to force a line shift, but in my case this is not an option. The tables that are the source of the charts are updated several times a week, both labelling and numbers. This means that all changes that are not "permanently", will disappear. Is there actually no other solution to this than making your own text boxes for all the tabels? And if this is the only solution, is there any possibility to make the drawing area EXACT the same size in several charts?

Thanks for any help...