Yeah, CFCHART picks ranges based on the data being charted, so if you want to force a certain range, you may need to pad. In my particular situation, however, that's not the case. It's just whatever data is in the range needs to be displayed. I.e. the range endpoints are insignificant. I just don't want CFCHART adding a bunch of extra space at the ends just for the sake of making "pretty" chart labels. But it's the same problem either way: no way to manually set the x-axis range rather than having it computed dynamically.
Steve's idea would probably work for your situation: specify the granularity as well as the range, but it's hardly ideal, since you can't compute the ranges dynamically at runtime (at least not easily). cheers, barneyb On 12/1/06, Tom McNeer <[EMAIL PROTECTED]> wrote: > Looking back at some old code, I was actually changing stylesheets based on > the user's selection of a date range. For instance, if s/he chose "3 years," > I chose a stylesheet that scaled the x-axis by month. If s/he chose "1 > month," I chose a stylesheet that scaled by days. > > As far as the range goes -- I haven't looked at the WebCharts application in > a long time. But the CFCHART tag has scaleMax and scaleMin attributes that > let you choose starting and ending values for the y-axis. I wonder if > there's a similar thing you can set for the x-axis in the XML. If so, you > might be able to spit out a few static stylesheets and choose among them > based on the range you receive. > > But won't the x-axis values start and end wherever the data you're pouring > in start and end? I haven't worked with CFCHART in a long time, so I may > well be misremembering. But it seems to me that I actually had to pad my > recordset to get what I wanted. > > For instance -- in my situation, the user chose a specific time period, as I > said. If s/he chose one year, my query looked for records going backward a > year. But if there were only records which went back two months, I had to > add a bogus row to my query with the starting date (Now() - 1 year, for > instance) in order to get the x-axis to begin one year ago. > > > -- > Thanks, > > Tom -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
