- Joined
- Jul 9, 2011
- Messages
- 1
- Reaction score
- 0
There are so many possiblities for using xy plots in Access 2007 forms, yet implementing graphs to show xy data is almost impossible! Please provide any demos or links to relevant tutorials. Give a good demo of Scenario 2, and come to Weaverville, CA, and I'll buy you a beer!
Scenario 1: just an xy plot
Given a query with two columns [x] and [y] of numbers, plot points for the x-y pairs. Label the axes with the column names (e.g. x and y).
Scenario 2: multiple profile lines
Given a query with three columns [x] [y] and [grp_id]. x and y much like before. grp_id indicates 2 or more groupings in the xy data such that xy pairs within a group should be linked by a line. Each group should have a different color and a legend should the colors used for each group.
[Actual use would be for elevation profiles (elevation = y; distance along a line = x). Profiles are repeated periodically, so grp_id is the survey date.]
Thanks for any help!!!
Scenario 1: just an xy plot
Given a query with two columns [x] and [y] of numbers, plot points for the x-y pairs. Label the axes with the column names (e.g. x and y).
Scenario 2: multiple profile lines
Given a query with three columns [x] [y] and [grp_id]. x and y much like before. grp_id indicates 2 or more groupings in the xy data such that xy pairs within a group should be linked by a line. Each group should have a different color and a legend should the colors used for each group.
[Actual use would be for elevation profiles (elevation = y; distance along a line = x). Profiles are repeated periodically, so grp_id is the survey date.]
Thanks for any help!!!