G
Guest
OBJECTIVE:
========
I'm working in MS Access 2003. My project deals with many "Topics". Users
are to rank each topic based on 2 categories, "Cat 1" and "Cat 2". Both Cat 1
and Cat 2 are ranked on a level from 1 to 10.
This happens twice during the course of the user working through my database
-- think like diet pictures "Before" and "After" using the database.
I want to produce a report that shows a scatter chart for each "Topic". The
chart will show 2 dots ... one represents "Before" and the second represents
"After." The dots' X-values will be the Cat 1 rank. The dots' Y-values will
be the Cat 2 rank.
QUESTION:
========
Can this be done? And how?
I'd appreciate any help I can get. (BTW, the scatter chart is a standard in
my business, so I don't want to change to a bar or other type of chart).
Please see below for what I've already tried.
Thanks!
-Debbie
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
WHAT I'VE TRIED:
============
Attempt 1
-----------
I created a table that listed (a) the topic, (b) the time -- Before or
After, (c) the X-value, and (d) the Y-value.
Problem 1
------------
I realized that an MSChart: Scatter Chart wants to use the 1st row as the
X-values. Apparently I can't set my table up that way. Additionally, the
exact same chart was repeated for each row in the table.
Attempt 2
-----------
I set up a table with columns and 1st row values of (a) topic, (b) the time
-- Before or After, (c) through (l) possible X-values of 1 through 10.
Each additional row listed the topic and time then the Y-value was entered
under the column for the appropriate X-value.
Problem 2
------------
This solution put dots in the right places. However, I could only get it to
show all the dots at one time. I could not figure out how to report each
topic and a scatter chart showing just the 2 dots for that topic.
Additionally, it added 1 extra dot for each topic on the Y-axis (i.e., X=0).
And again, the identical chart was shown for each row of the table ...
including the 1st row that only lists the X-values.
========
I'm working in MS Access 2003. My project deals with many "Topics". Users
are to rank each topic based on 2 categories, "Cat 1" and "Cat 2". Both Cat 1
and Cat 2 are ranked on a level from 1 to 10.
This happens twice during the course of the user working through my database
-- think like diet pictures "Before" and "After" using the database.
I want to produce a report that shows a scatter chart for each "Topic". The
chart will show 2 dots ... one represents "Before" and the second represents
"After." The dots' X-values will be the Cat 1 rank. The dots' Y-values will
be the Cat 2 rank.
QUESTION:
========
Can this be done? And how?
I'd appreciate any help I can get. (BTW, the scatter chart is a standard in
my business, so I don't want to change to a bar or other type of chart).
Please see below for what I've already tried.
Thanks!
-Debbie
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
WHAT I'VE TRIED:
============
Attempt 1
-----------
I created a table that listed (a) the topic, (b) the time -- Before or
After, (c) the X-value, and (d) the Y-value.
Problem 1
------------
I realized that an MSChart: Scatter Chart wants to use the 1st row as the
X-values. Apparently I can't set my table up that way. Additionally, the
exact same chart was repeated for each row in the table.
Attempt 2
-----------
I set up a table with columns and 1st row values of (a) topic, (b) the time
-- Before or After, (c) through (l) possible X-values of 1 through 10.
Each additional row listed the topic and time then the Y-value was entered
under the column for the appropriate X-value.
Problem 2
------------
This solution put dots in the right places. However, I could only get it to
show all the dots at one time. I could not figure out how to report each
topic and a scatter chart showing just the 2 dots for that topic.
Additionally, it added 1 extra dot for each topic on the Y-axis (i.e., X=0).
And again, the identical chart was shown for each row of the table ...
including the 1st row that only lists the X-values.