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 Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:262550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
