Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Charting In Access (XY Scatter Plot)

Discussion in 'Information Technology' started by millie.patel@gmail.com, Jul 28, 2006.

  1. millie.patel@gmail.com

    Expand Collapse

    Hi All,

    I have an access report that I need to embed a chart --

    The chart needs to range from 0 - 4 (allowing for .5 increments)

    The query I am basing this off of has the following fields:

    -BaselineIndicator --> 1
    -BaselineIndicatorLabel --> Q1 06
    -CurrentIndicator --> 2
    -CurrentIndicator Label --> Q3 06
    -IndustryIndicator --> 2.5
    -IndustryIndicatorLabel --> Industry
    -TargetIndicator --> 4
    -TargetIndicatorLabel --> Target

    Each one of the indicators can range from 0 - 4; and the labels just
    describe what the indicators are at a given point (i.e.
    baslineindicator label could be Q2'06 for second quarted of 2006)...

    When I try to plot these using access, it counts all the different
    indicators as ONE series, i would like them to be plotted individually
    on one horizontal line:

    0 1 2 2.5 3 4
    Baseline Current Industry Target

    Can this be done?


  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page