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

    millie.patel@gmail.com
    Expand Collapse
    Guest

    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?

    Thanks,

    Millie
     
  2. Loading...


Share This Page