On the X Axes of my chart it puts 1/2 of the title on the next line.
ex: Gross Sales Per
Month
I have tried everything to make it all in one line. Some of my charts does
it perfect and then some of them come out this way....any suggestions.
On the X Axes of my chart it puts 1/2 of the title on the next line.
ex: Gross Sales Per
Month
I have tried everything to make it all in one line. Some of my charts does
it perfect and then some of them come out this way....any suggestions.
In a cell on the worksheet, type the title, and press Alt+Enter at the
spot you'd like the line to break. For example:
Gross Sales
Per Month
Select the axis title in the chart
Type an equal sign, and click on the cell that contains the title text
In the formula bar, you'll see the reference, e.g.: =Sheet1!$M$2
Press the Enter key to complete the entry.
yorkielover02 wrote:
> On the X Axes of my chart it puts 1/2 of the title on the next line.
> ex: Gross Sales Per
> Month
>
> I have tried everything to make it all in one line. Some of my charts does
> it perfect and then some of them come out this way....any suggestions.
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks