I enabled sortxaxis as "yes" and it now works apart from the
fact that the data points do not connect properly. it seems that
they will connect until a different supplier puts a bid in. see
example chart at:
http://img166.imageshack.us/my.php?image=chartbidsxl8.jpg
<cfchart chartheight="325" chartwidth="475" format="png"
font="Arial" fontbold="Yes" seriesplacement="default"
labelformat="number" showBorder="Yes" showLegend="Yes"
showMarkers="Yes" sortxaxis="yes" xaxistitle="Date/Time"
xaxistype="Category" yaxistitle="Bid Amount"
tipstyle="mouseOver">
<CFLOOP INDEX="ListSuppliers" LIST="#Suppliers#">
<CFQUERY DBTYPE="query" NAME="GetChartData2">
SELECT * FROM GetChartData
WHERE SupplierID='#ListSuppliers#'
</CFQUERY>
<cfchartseries type="line" query="GetChartData2"
itemcolumn="Bid_Date" valuecolumn="Bid"
serieslabel="#GetChartData2.Company#" markerstyle="circle"
paintstyle="plain" />
</CFLOOP>
</cfchart>