Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    truncated X-axis label (97)

    Edited by unkamunka to reduce size of graphic and to prevent scrolling

    Hey,
    does anyone have an explanation/solution for Excel truncating X-axis labels? I've included an example. Changing the format of the labels doesn't help and it seems frustratingly at random...
    Hasse

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: truncated X-axis label (97)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Hasse

    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17> Why are you still working with 97. I love it, but MS needs your money, so upgrade <img src=/S/broke.gif border=0 alt=broke width=31 height=23>

    OK check these for size:

    MSKB Article - 165612 - Axis Labels Missing on Profitability Chart
    MSKB Article - 174170 - Column and Area Chart Y Axis Is Scaled in Microsoft Excel 97
    MSKB Article - 115341 - Column Charts May Not Show All Data Labels

    I used Chart axis as search words and I got 54 articles, maybe you would try different search words.

    HTH

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  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: truncated X-axis label (97)

    What is wrong with XL97? <img src=/S/sarcasm.gif border=0 alt=sarcasm width=15 height=15>

    That is what I am still using, and I might not have all the "new-fangled" bells-and-whistles that come with newer versions, it still does what I want, and I can still use it to do what most of the people are asking in the excel board, so I don't feel I am missing anything. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    I do not plan on changing until our company changes. I do not like using a different program at home than I do at work, it just confuses me (and at my age and "witlessness" I can't afford to be confused). <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    Steve

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: truncated X-axis label (97)

    I agree that XL97 is not that much different from the later releases. They are more stable though. Especially Excel XP is an improvement in that respect.
    Most of the rest is just cosmetics, except the improved stats functions in Excel 2003 (after MS has fixed the RAND bug, that is).

    I do expect mayor changes with the next version...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: truncated X-axis label (97)

    >I do expect mayor changes with the next version...
    <img src=/S/whisper.gif border=0 alt=whisper width=29 height=17>Anything that you can share with us?
    Gre

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: truncated X-axis label (97)

    I am under an NDA with Microsoft about these matters I'm afraid.

    But let me just say MS is finally really discussing things with the MVP group and seems to actually listen to our arguments and suggestions.
    We tend to be able to make our point about many things.
    One of our recent victories is the work MS has been doing on the stats functions for XL2003 (although they did make a mistake with the RAND() function).

    I am not allowed to go into more detail than that though.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: truncated X-axis label (97)

    Edited by <!profile=unkamunka>unkamunka<!/profile> to make the link "live" - see <!help=19>Help 19<!/help>

    Hey, guys,
    I searched KB & google a bit further without much success really, untill one word pointed me in the right direction though: printing... Et voila: when printed, the labels are shown correctly[/b]! This doesn't really help because I have to hand over the graphs to a collegue (which will make screenshots & do some more editing in Photoshop for publication)... but at least it explains something... and a clue for a workaround.
    Fortunately I've Acrobat Distiller, so I will try printing the graph's to a PDF document. As such, if the 'image' quality is acceptible, I'll have the required graph digitally & correctly!
    <img src=/S/coffeetime.gif border=0 alt=coffeetime width=32 height=48>
    Thanks for the feedback (& side discussion ;-).

    Hasse

    ps FYI: what I tried in Excel but didn't help either:
    - changing font size
    - changing outlining: vertically / horizontally
    - changing format: dd/mm or dd/mm/yy (then either the last m/y is randomly omitted)
    - activating automatic scaling

    ps I almost forgot: at our administration, we can migrate to Office XP (since +- a year) but I prefer Office 97 untill 'everybody' can/will migrate because of Word: I've had too many writing hours wasted due to Word's instability problems caused by using different Office versions. (There are probably ways to avoid those, but it's hard to force all users doing so.) Further, Office 97 can (mostly) do whatever we need and... is sometimes even more comfortably to the 'conservative' user (like the help files, mail merge,...) <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

  8. #8
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: truncated X-axis label (97)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Hasse

    For the update, and I am glad it worked for you, and the PDF solution is probably what I would have done.

    Go for it.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  9. #9
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: truncated X-axis label (97)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Steve

    Yes I was forced into upgrading to Office 2003, It should be 203 or even 3 if you ask me.

    You may have heard my ranting about Outlook, and now I have finally gotten all the screen shots I wanted to show.

    BUT!!! the killer is not yet here. I had the chance to crash MS-Word 2003, and I sent a report to MS. Please don't <img src=/S/bash.gif border=0 alt=bash width=35 height=39> me, it was a moment of weakness. It said that I could install an update and when I went to the update site, it told me that I can't update for some reason only MS will know.

    You are only missing the heartaches, nothing more. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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