Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / January 2007

Tip: Looking for answers? Try searching our database.

Line break

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Beryl - 08 Nov 2006 21:24 GMT
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 - 08 Nov 2006 21:38 GMT
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.
Andy Pope - 09 Nov 2006 09:08 GMT
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.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.