I got my answer - CFCHART sucks. :) It seems that there is no way to format x-axis data using either cfchart or cfchartseries. I had to be creative and loop through my query, changing the value of each row to be a nicely formatted date. Ugly solution, but it works. More info can be found in the comments section of this livedoc:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a11.htm Just FYI, for anyone that might read this in the archives! Ray At 03:25 PM 4/5/2005, you wrote: >I am making a simple line chart for the first time and I have run into an >easy stumbling block that I can't seem to Google out. > >The Y-Axis are a series of prices, while the X-Axis is a series of >dates. These are held in a DB. The problem that I am having is that the >date always outputs on the X-Axis label as the SQL date, ie; 2005-05-05 >00:00:00.0. No matter what I try, I can't get it to diplay as a simple >date, like 05/05/2005. > >There has to be something I am missing here - I see a place to format the >data for the Y-Axis, why not the X-Axis? I know that I can flip the chart, >but I don't want to do that. > >Ray > >============================================= >Ray Champagne - Senior Application Developer >CrystalVision Web Site Design and Internet Services >603.433.9559 >www.crystalvision.org >============================================= > >The information contained in this transmission (including any attached >files) is CONFIDENTIAL and is intended only for the person(s) named >above. If you received this transmission in error, please delete it >from your system and notify us immediately. If you are not an intended >recipient, please note that any use or dissemination of the information >contained in this transmission (including any attached files) and the >copying, printing, or retransmission of that information is strictly >prohibited. You can notify us by return email or by phone at 603.433.9559. >Thank you. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201601 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
