Re: Does anyone care about DFS?
- From: CDMAPoster@xxxxxxxxxxxxxxxx
- Date: 12 Jul 2006 17:32:30 -0700
DFS wrote:
CDMAPoster@xxxxxxxxxxxxxxxx wrote:
I'll try to find time this week to work on a PDF scatter chart mdb.
Any requests for features DFS? I care.
It's so nice to find people who care... sniff sniff...
But seriously, no need to burn your time unless you can't help yourself. My
hand-coded scatter chart works well for my needs:
http://www.angelfire.com/planet/dfs0/Scatter.PNG
See that datasheet on the right? As you scroll it, the current month is
highlighted in red on the chart. Kewl!
Here's the positioning code (added some height/width kludges to deal with
the labels in the corners). I may work on autoscaling (would be easy), but
the data sets have pretty tight ranges.
'X-AXIS POSITION
XPos = ((rs("X") - 0.8) / 0.2) * (0.5 * frm.scatterBox.Width)
If XPos <= 0 Then
XPos = 10
ElseIf XPos > frm.scatterBox.Width Then
XPos = frm.scatterBox.Width - 100
End If
frm("point" & i).Left = scatterLeft + XPos
'Y-AXIS POSITION
YPos = ((rs("Y") - 0.8) / 0.2) * (0.5 * frm.scatterBox.Height)
If YPos <= 0 Then
YPos = 10
ElseIf YPos > frm.scatterBox.Height Then
YPos = frm.scatterBox.Height - 300
End If
frm("point" & i).Top = scatterBottom - YPos
I'm thinking about small red circles with a black border for that
points. PDF has to use Bezier Curves for circles so I'm thinking
along these lines:
<snip nice code>
Thanks for the offer.
I think I need at least one person to request that I do the scatter
plot to justify spending time on it although it sounds fun. What you
have looks nice. I think the PDF output gives more flexibility
although being able to show a scrollable view of the data next to the
plot is very nice. I'd end up going into the graphics API to retain
the kind of flexibility I like in order to have that feature. The API
calls can handle the red month also, but I agree that it's a nice touch
either way. I'm glad it worked out for you.
James A. Fortune
CDMAPoster@xxxxxxxxxxxxxxxx
.
- References:
- Does anyone care about DFS?
- From: polite person
- Re: Does anyone care about DFS?
- From: polite person
- Re: Does anyone care about DFS?
- From: Lyle Fairfield
- Re: Does anyone care about DFS?
- From: CDMAPoster
- Re: Does anyone care about DFS?
- From: DFS
- Does anyone care about DFS?
- Prev by Date: Re: Query Question
- Next by Date: Re: Dates in where clause
- Previous by thread: Re: Does anyone care about DFS?
- Next by thread: Re: Does anyone care about DFS?
- Index(es):
Relevant Pages
|