Welcome to SPN

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

Sign Up Now!

Please Help - Chart in Form -

Discussion in 'Information Technology' started by Trial & Error, Nov 9, 2005.

Tags:
  1. Trial & Error

    Trial & Error
    Expand Collapse
    Guest

    I have a form that displays several charts... all working well, until I tried
    adding the final chart that I require... I cannot seem to get it to work the
    way I would like.

    At the table level I have two fields "SCOUNT" and "SGRADE"... when an entry
    is made, scount collects a # of visitors, and sgrade makes note of their
    school grade.

    I have run a query that collects SCOUNT and SGRADE. The results look
    somthing like so:
    SGRADE SCOUNT
    4 10
    7 22
    9 100
    4 25
    5 10
    4 100

    I altered the totals row of the query, and set SGRADE to "Group By", and
    SCOUNT to "Sum". Now I get this
    SGRADE SCOUNT
    4 135
    5 10
    7 22
    9 100

    GREAT... works just fine... exactly how I would like.
    Now I am trying to display these results as a pie chart. Where the chart is
    broken down to show each grade as a percentage of the whole.
    I am able to generate the chart... but when it runs, It appears once for
    each recordset... ie. one chart for grade 4, one for 5, one for 7 etc... Each
    time it displays each grade as 1 single slice of the pie.

    What I would like is for each grade to show on the SAME chart, so that the
    chart denotes a breakdown of how each grade compares to eachother............

    is this making sense??
    any help would be appreciated....

    Thanks in advance
     
  2. Loading...

    Similar Threads Forum Date
    General Help! Looking for a good clairvoyant/card reader......any suggestions? Please Blogs Jan 25, 2016
    Please help Questions and Answers Nov 1, 2013
    Please Help! What is the Name of the Narrator/Raagi? Gurbani Download Oct 16, 2012
    Muslim Girl-Sikh Boy Marriage Problems- Please Help! Love & Marriage Oct 12, 2012
    Help Please :/ Relationships Apr 19, 2011

Share This Page