Hi Beryl
Will a 'Soft Return' do the trick?
To do a 'Soft Return' click where you want to insert your line break, hold
down the Shift key and press Enter. This will break the line into 2 lines
but keep it as one paragraph. This trick works in almost every program.
Is this what you wanted to know Beryl?
Cheers
-SuperPresentationMan
"Our PowerPoint Hero"
www.SuperPresentationMan.com
| Custom PowerPoint Template Design | PowerPoint Makeovers |
| PowerPoint Trouble Shooting | Custom PowerPoint Graphics & Clip Art |
| Into PowerPoint | Out of PowerPoint | SGI Showcase to PowerPoint |
> How do I insert line break in a PowerPoint data chart? I neeed the tick
> label
> in a bar chart do go on 2 lines.
Echo S - 09 Nov 2006 04:01 GMT
This doesn't work in any version of MS Graph after PPT 95.
Alt+Enter works in Excel cells, though, and if you do your chart in Excel,
it respects the line break(s) in the cell(s).
In PPT, you can get a line break in the chart title and the axis titles
(both Ctrl+Enter and Shift+Enter work), but not in the axis labels
themselves.

Signature
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
> Hi Beryl
>
[quoted text clipped - 20 lines]
>> label
>> in a bar chart do go on 2 lines.
Hi,
You can not do it manually, as Echo points out. But you can do it with code.
To test this open a new ppt file and insert a graph.
Open the graphs Datasheet and edit the axis labels placing a | character
where you want the label to wrap.
The exit from msgraph and use this code to insert a Linefeed.
'----------------------------------------
Sub WrapAxisLabels()
Dim lngCol As Long
' change slide and shape references.
With ActivePresentation.Slides(1).Shapes(3). _
OLEFormat.Object.Application.datasheet
' check 1st row for labels
lngCol = 2
Do While .Cells(1, lngCol) <> ""
.Cells(1, lngCol) = Replace(.Cells(1, lngCol), "|", vbLf)
lngCol = lngCol + 1
Loop
' Use this if axis labels are in the 1st Row
' lngRow = 2
' Do While .Cells(lngRow, 1) <> ""
' .Cells(lngRow,1) = Replace(.Cells(lngRow, 1), "|", vbLf)
' lngRow = lngRow + 1
' Loop
End With
End Sub
Cheers
Andy
> How do I insert line break in a PowerPoint data chart? I neeed the tick label
> in a bar chart do go on 2 lines.

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Echo S - 09 Nov 2006 17:33 GMT
Hey, cool! Thanks, Andy.

Signature
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
> Hi,
>
[quoted text clipped - 38 lines]
>> How do I insert line break in a PowerPoint data chart? I neeed the tick
>> label in a bar chart do go on 2 lines.
Extra - 29 Jan 2007 22:33 GMT
I also need to insert a line break in an axis label in PP - I understand how
to insert the | character but do not understand where to enter this code -
can you help? Thanks.
> Hi,
>
[quoted text clipped - 37 lines]
> > How do I insert line break in a PowerPoint data chart? I neeed the tick label
> > in a bar chart do go on 2 lines.
Echo S - 31 Jan 2007 15:51 GMT
How do I use VBA code in PowerPoint?
http://www.pptfaq.com/FAQ00033.htm
This should get you started. You'd add the pipe character | and then click
the slide to close MSGraph and then follow the instrux in FAQ 033.

Signature
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
>I also need to insert a line break in an axis label in PP - I understand
>how
[quoted text clipped - 44 lines]
>> > label
>> > in a bar chart do go on 2 lines.