Once you start wanting anything simple out of CF charts you need to use the chart builder. With that tool you can do an amazing amount of layout work. You can then use the resulting xml to feed into CF charts to get the layout you want. That includes date formatting.
It has been a while since I did it so can't remember the exact details but it wasn't too hard. Cheers, Simon On 18 March 2011 12:56, Scott Thornton <scott.thorn...@hnehealth.nsw.gov.au>wrote: > Hello, > > > > Couldn't you summarise your data in your query the first place? > > > > eg: > > select > > left(datename(month, my_date ),3) +'-'+ datename( year, my_date) as > period, > > count( of something ) as my_count > > from > > my_table > > group by > > left(datename(month, my_date ),3) +'-'+ datename( year, my_date) > > > > ( MS SQL ) > > > > which would return > > Dec-1989 etc? > > > > much quicker imo. > > > > > > *From:* cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] *On > Behalf Of *rai...@ozemail.com.au > *Sent:* Friday, 18 March 2011 12:49 PM > *To:* cfaussie@googlegroups.com > *Subject:* [cfaussie] CFChart X axis value formatting > > > > Hi I have creating line graphs using cf charge and the dates are on the x > axis > > > > the date values in the sql tables being drawn on in the chart are datetime > format and as a result I am having the date and time appearing on the x > axis for each point on the chart > > > > as their a way I can alter the display format of the values similar what is > done using the DateFromat() do that my dates along the x axis only show in > a month-year eg "jan-11" rather than "01/01/11 10:55.00AM" > > > > Regards > > Claude Raiola (B.Econ Acc; B.Hot. Mngt) > [image: logo_new] > Email: i...@trackingcentral.com.au <i...@trackingcentral.om.au> > Website: www.TrackingCentral.com.au <http://www.trackingcentral.com.au/> > FREE CALL: 1300 255 990 > > > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaussie@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. > -- Cheers Simon Haddon Woman loves feeling danger and speed. That is why woman wants man. They get a speed rush that is the most dangerous of all. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
<<image001.gif>>
