Results 1 to 10 of 10
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Chart Formatting (2003/SP3)

    The attached workbook attempts to show the aging of items (invoices, correspondence awaiting a response, etc). I would much prefer to have the columns placed between the tick marks so that it is obvious that there are two items that are between one and two months old. I have been unable to achieve this. Help!

    Many thanks in advance.
    Attached Files Attached Files
    Regards
    Don

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

    Re: Chart Formatting (2003/SP3)

    Double-click the horizontal axis (or click on the horizontal axis and select Format | Selected Axis...)
    Activate the Scale tab.
    Tick the check box "Value (Y) axis crosses between categories"
    Click OK.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart Formatting (2003/SP3)

    If I am not mistaken, would a stacked chart not do that?
    Attached Images Attached Images
    Regards,
    Rudi

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart Formatting (2003/SP3)

    Hi Hans and Rudi
    Perhaps I was unclear; the effect that I am attempting to achieve is shown below with the X axis scale aligned with the tick marks, but the columns between the tick marks. Any ideas?
    Attached Images Attached Images
    Regards
    Don

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart Formatting (2003/SP3)

    Hans
    In the attached file I have achieved almost the results I am after by introducing additional columns in my source data. This results in either having too many tick marks or none on the X axis. Any ideas?

    TIA
    Attached Files Attached Files
    Regards
    Don

  6. #6
    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: Chart Formatting (2003/SP3)

    You can do it by using a dummy range.

    Plot the columns from a secondary X-axis (Offset) with an axis not displayed and using the Primary X-Axis with no data in the Y range.

    Steve
    Attached Files Attached Files

  7. #7
    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: Chart Formatting (2003/SP3)

    A comment on your chart. Shouldn't you eliminate the ">12" category or change the "12" to something like "12 and up" or ">12"?

    As the chart is displayed the value to the right of the 12 implies ">12"....

    Steve

  8. #8
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart Formatting (2003/SP3)

    Steve
    I thought that I had replied to this post six hours ago. Must have hit a wrong key in my haste. You're a saviour. Thank you.
    Regards
    Don

  9. #9
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Chart Formatting (2003/SP3)

    You are absolutely correct. Thanks.
    Regards
    Don

  10. #10
    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: Chart Formatting (2003/SP3)

    Glad I could help. If it is not clear from the example how it was done, let me know and I can provide details...

    Steve

Posting Permissions

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