Line break

[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.

 

[SuperPresentationMan]

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 |

 

[Echo S]

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.

 

[Andy Pope]

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

 

[Echo S]

Hey, cool! Thanks, Andy.

 

[Guest]

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.

 

[Echo S]

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.