Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Dec 2006
    Posts
    35
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel graphs (Office Basic 2003)

    It's a small thing but very annoying. I find that whenever I create a graph in Excel, the label on the upright axis tends to cut off the last letter or letters. For instance if the label is 'Million tonnes CO2', part of the CO2 is not visible. I have tried changing fonts and font sizes, usually to no avail. And even when I shorten or abbreviate the label (eg 'Mn tns CO2') I find the CO2 might still be chopped off. Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel graphs (Office Basic 2003)

    This problem is mentioned very frequently in the Excel newsgroups. It occurs on some PCs, not on others. There doesn't appear to be a satisfactory explanation or solution.

    One thing to check is that the text orientation (in the Alignment tab of the Format Axis dialog) is set to -90, 0 or 90 degrees. These orientations allow text wrapping.

    A clunky workaround suggested in the newsgroups is to add some spaces followed by a period to the text for the axis labels:
    <pre>Million tonnes CO2 .
    </pre>

    The period will be truncated. The disadvantage of this workaround that the period will be visible on PCs that don't have the problem.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel graphs (Office Basic 2003)

    I presume that the period is so that Excel will not trim the spaces (as it does in some cases).

    A "Sticky space" (<alt>0160) is still "clunky" but would not have the period on PCs without the problem.

    Steve

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel graphs (Office Basic 2003)

    I haven't actually tried it (the problem doesn't occur on my home PC or my work PC), but using Alt+160 looks like a good idea.

  5. #5
    4 Star Lounger
    Join Date
    Feb 2006
    Location
    Cape Cod, Massachusetts, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel graphs (Office Basic 2003)

    Steve,
    That's a great little suggestion. I had not come across that before.

    Paul

Posting Permissions

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