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.

Power Point Axis Tit;e

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Extra - 29 Jan 2007 21:04 GMT
How do I insert a manual line break into the category axis title of a chart?
David M. Marcovitz - 29 Jan 2007 21:12 GMT
> 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
Bill Dilworth - 30 Jan 2007 15:21 GMT
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?
Andy Pope - 30 Jan 2007 16:32 GMT
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

 
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.