Thread: Creating Bubble Chart
06-21-02, 11:33 #1Registered User
- Join Date
- Apr 2002
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
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 ?
06-28-02, 09:59 #2Registered User
- Join Date
- Jun 2002
- Mpls/St.Paul area
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
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.
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.