#1   Report Post  
yorkielover02
 
Posts: n/a
Default CHART AxES TITLE

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.

  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relative Chart Title? Nick M Charts and Charting in Excel 6 June 22nd 05 09:24 PM
Problem with Chart Title Formatting KvnLynch Charts and Charting in Excel 1 January 12th 05 03:15 AM
3D Chart with Continuous Data in all three Axes Barb Reinhardt Charts and Charting in Excel 3 January 10th 05 07:09 PM
how to cell reference a Chart title Rasoul Khoshravan Azar Charts and Charting in Excel 2 January 1st 05 05:00 PM
Excel Chart y-axis title Kuzemdoo Dawuni Excel Discussion (Misc queries) 1 December 3rd 04 02:43 AM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"