> How do I insert a manual line break into the category axis title of a
> chart?
When you insert a category axis title, you can click on the title, and it
will behave much like a regular text box. You can click where you want in
the text and hit Enter.
--David

Signature
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
Extra - 29 Jan 2007 23:37 GMT
Thank you. I used the wrong term. I need to enter a line break into a
category axis label or name
> > How do I insert a manual line break into the category axis title of a
> > chart?
[quoted text clipped - 3 lines]
> the text and hit Enter.
> --David
David M. Marcovitz - 30 Jan 2007 15:02 GMT
I believe that the only way to do this is to ungroup the chart. While the
data table is not showing, click on the chart to select it. Then choose
Ungroup from the Draw menu on the Draw toolbar. This will cut all ties to
the data table so be sure that you are done with all your data before
doing this. Once you have ungrouped, the labels should behave like normal
text boxes.
--David

Signature
David M. Marcovitz
Microsoft PowerPoint MVP
Director of Graduate Programs in Educational Technology
Loyola College in Maryland
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
> Thank you. I used the wrong term. I need to enter a line break into a
> category axis label or name
[quoted text clipped - 6 lines]
>> you want in the text and hit Enter.
>> --David
Hi Extra,
The labels created by PowerPoint's graphing program (MSGraph) can not have
manual line break inserted while they are still graphs tied to a data table.
MS Graph is a fairly limited program. I haven't played with this in VBA
code, but it may be possible to write a small macro to add these. However,
if you ungroup the chart (and therefore unlink it from the table) than the
individual textboxes can have line returns inserted.

Signature
Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
.
> How do I insert a manual line break into the category axis title of a
> chart?
Hi,
If you can use vba here is a routine to replace spaces in the header row
or column of the msgraph data sheet. If the text contains multiple
spaces you might want to pick a special character, such as ^, and insert
that in the text before running the code.
Sub x()
'
' Replace space in axis label with new line
'
Dim lngRow As Long
Dim lngCol As Long
With ActiveWindow.Selection.ShapeRange.OLEFormat.Object
With .Application
If .PlotBy = xlRows Then
lngCol = 2
For lngCol = 2 To _
.Chart.SeriesCollection(1).Points.Count + 1
.DataSheet.Cells(1, lngCol).Value = _
Replace(.DataSheet.Cells(1, lngCol).Value, _
" ", vbCrLf)
Next
Else
lngRow = 2
For lngRow = 2 To _
.Chart.SeriesCollection(1).Points.Count + 1
.DataSheet.Cells(lngRow, 1).Value = _
Replace(.DataSheet.Cells(lngRow, 1).Value, _
" ", vbCrLf)
Next
End If
.Update
.Quit
End With
End With
End Sub
Another possible option, depending on chart type, is to use data labels
as axis labels. You can then manually edit the data labels and add new
lines.
Cheers
Andy
> How do I insert a manual line break into the category axis title of a chart?

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info