Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    MultiLine Axis Labels (Any)

    Using MS graph, is there a way of forcing an axis lable to be two lines, ie an equivalent to Excel's <Alt><Enter>.

    For example, create a new presentation with a new chart slide. The default data has 1st Qtr, 2nd Qtr, etc. in the first row. Suppose I want<pre> First
    Quarter</pre>

    instead on the axis with 2 lines, left-justified. The only way I can figure is to insert spaces between First and Quarter until it becomes two lines, but it never lines up just right and if I resize the chart, I have to start over. TIA --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: MultiLine Axis Labels (Any)

    Sammy,

    I'm using ppt 97/office 97 (and hence the MSGraph that comes with 97). Doing half of what you want is easy in that environment.

    As you observed, the labels in the default chart are "1st Qtr" etc. Even spelling out "Qtr" as "Quarter" still results in a 1-line label - in the default point size. If you double-click a label (or right click on it and choose Format Axis), you'll be in a dialog where 1 of the tabs is Font. This is the usual collection of things - including Font Size. The default size is 18 pts. Just changing this to 20 (with Qtr spelled out) will push the Quarter to a 2nd line. However, there seems no way to left justify that I can see in ppt 97 - I think you're stuck with centering (unless you play with spaces as mentioned). Similarly, if you use shorter words, you'd need a pretty big font size to push the 2nd word onto a 2nd line - it may get to looking ugly.

    The Alignment tab on the above dialog doesn't help.

    Fred

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: MultiLine Axis Labels (Any)

    Sammy,

    If you drop your constraint of "using MS Graph", you can always paste an Excel Chart into ppt. My little experiment in Excel showed that if you use ALT+Enter in Excel for an x-axis label, Excel's chart will show the label on 2 lines. In fact, you can have labels mixed - some with ALT+Enter between words and some without.

    However, it doesn't matter whether the cell with the label is left, center or right aligned. The chart label still comes out centered across whatever lines are used.

    And guess who's site shows how to paste an Excel Chart into ppt using VBA? See <A target="_blank" HREF=http://www.geocities.com/jonpeltier/Excel/XL_PPT.html>Jon Peltier's site </A> ! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Fred

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •