Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Creating Bubble Chart

    I am creating a bubble chart based on this table.

    My table looks like this :

    Point X Y Size
    A 1 2 3
    B 4 5 6

    etc

    So just like simple mathematic chart for example, I have a
    point called A which has a X coordinate of 1 and Y
    coordinate of 2, however, instead of all points have the
    same size, the size depends its size field. Also, the
    legend will indicate A, B and so on.

    This is quite easy to do in Excel, however, I am not sure
    how I set this up (chart row source) in Access.

    Any suggestion ?

  2. #2
    Join Date
    Jun 2002
    Location
    Mpls/St.Paul area
    Posts
    303

    Smile

    I was able to get it when I made the rowsource look like this...

    SELECT tblChart.Point, Sum(tblChart.Size) AS SumOfSize, Sum(tblChart.X) AS SumOfX, Sum(tblChart.Y) AS SumOfY
    FROM tblChart
    GROUP BY tblChart.Point;


    Oops. After scrutinizing my attempt and adding more data points... I'm failrly certain I don't know what I'm talking about. Tried lots of things, but I can't figure it out.


    Sorry.

    Last edited by jpshay; 06-28-02 at 10:15.
    John
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

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