+ Reply to Thread
Results 1 to 2 of 2

Need vertical separators rising from the X axis.

  1. #1
    Peter Jason
    Guest

    Need vertical separators rising from the X axis.

    I have Access2003 & WindowsXP and MSGraph2000.

    *****

    I have many charts based on MSGraph using xtab queries as the sources.

    All works well except for one small problem.

    Since I have all data shown monthly for over 7 years, this adds up to a
    pretty dense chart, which is excellent for discerning trends.

    (The X axis is always the "yyyymm" one.)

    Now what I need is a simple VERTICAL separator (rising from the X axis) on
    the chart to separate the years in either calendar or financial years.

    The Y axis has these built in and their separation can be adjusted.

    Why not for the X axis?

    Can someone help me to insert such separators, or is there 3rd-party
    software to do this?

    Please help, Frank

    ***



  2. #2
    Tushar Mehta
    Guest

    Re: Need vertical separators rising from the X axis.

    Consider adding major gridlines for the x-axis.

    And, please pass on the answer to Frank Martin of Australia who asked
    the exact same question as you.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>, [email protected]
    says...
    > I have Access2003 & WindowsXP and MSGraph2000.
    >
    > *****
    >
    > I have many charts based on MSGraph using xtab queries as the sources.
    >
    > All works well except for one small problem.
    >
    > Since I have all data shown monthly for over 7 years, this adds up to a
    > pretty dense chart, which is excellent for discerning trends.
    >
    > (The X axis is always the "yyyymm" one.)
    >
    > Now what I need is a simple VERTICAL separator (rising from the X axis) on
    > the chart to separate the years in either calendar or financial years.
    >
    > The Y axis has these built in and their separation can be adjusted.
    >
    > Why not for the X axis?
    >
    > Can someone help me to insert such separators, or is there 3rd-party
    > software to do this?
    >
    > Please help, Frank
    >
    > ***
    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1