Line break

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 |
 
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.
 
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
 
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.
 
Back
Top