Ok i have figured out that i need an xy scatter chart to display the information i have (i think)
I have some data stored in my database that run behind my VB front end. For simplicity sake i will
give explain only fields required.
RA# - agreement Number
StartDate - start date agreememnt
EndDate - end date of agreement
now i have worked out how to display this information out so that i get a visual of the RA# and the dates it happens.
my problem is that the ra# themselves can range from 1 - 10000 (or whatever)
if i was to try and display RA# 20 and 700 on the same chart, it would be so small that you could not see the result
is there a way to just spread the ra# up the y axis evenly and the lable what they are?
do you uinderstand or am i confused myself?
thanks in advance