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