cfchartseries

Description

Used with the cfchart tag. This tag defines the chart style in which the data displays: bar, line, pie, and so on.

Syntax

<cfchartseries 
   colorlist = "list">
   itemColumn="queryColumn"
   markerStyle="style"
   paintStyle="plain, raise, shade, light"
   query="queryName"
   seriesColor="Hex value or Web color" 
   seriesLabel="Label Text"
   type="type"
   valueColumn="queryColumn"
   dataLabelStyle="style"
</cfchartseries>

History

ColdFusion MX 7: Added the dataLabelStyle attribute and the horizontalbar chart type.

ColdFusion MX 6.1: Changed interpolation behavior: the tag now interpolates data points on line charts with multiple series.

ColdFusion MX: Added this tag.

Attributes

Attribute	Req/Opt	Default	Description
colorlist	Optional		Sets colors for each data point. Applies if the `cfchartseries` `type` attribute is `pie`, `pyramid`, `area`, `horizontalbar`, `cone`, `cylinder`, or `step`. Comma-delimited list of hexadecimal values or supported, named web colors; see the name list and information about six- and eight-digit hexadecimal values in the `cfchart` Usage section. For a hexadecimal value, use the form `"##xxxxxx"` or `"##xxxxxxxx"`, where x = 0-9 or A-F; use two number signs or none.
itemColumn	Required if `query` attribute is specified		Name of a column in the query specified in the `query` attribute; contains the item label for a data point to graph.
markerStyle	Optional	rectangle	Sets the icon that marks a data point for two-dimensional line, curve, and scatter graphs: rectangle triangle diamond circle letter mcross snow rcross
paintStyle	Optional	plain	Sets the paint display style of the data series: plain: solid color. raise: the appearance of a button. shade: gradient fill, darker at the edges. light: a lighter shade of color; gradient fill.
query	Optional		Name of the ColdFusion query from which to get data to graph.
seriesColor	Optional		Color of the main element (such as the bars) of a chart. For a pie chart, the color of the first slice. Hexadecimal value or supported named color; see the name list and information about six- and eight-digit hexadecimal values in the Usage section for the `cfchart` tag. For a hexadecimal value, use the form `"##xxxxxx"` or `"##xxxxxxxx"`, where x = 0-9 or A-F; use two number signs or none.
seriesLabel	Optional		Text of the data series label
type	Required		Sets the chart display style: bar line pyramid area horizontalbar cone curve cylinder step scatter pie
valueColumn	Required if `query` attribute is specified		Name of a column in the query specified in the `query` attribute; contains data values to graph.
dataLabelStyle	Optional	None	Specifies the way in which the color is applied to the item in the series: none: nothing is printed. value: the value of the datapoint. rowLabel: the row's label. columnLabel: the column's label. pattern: combination of column label, value, and aggregate information, such as columnLabel value for the percentage of total graph; for example, Sales 55,000 20% of 277,000.

Usage

For a pie chart, ColdFusion sets pie slice colors as follows:

If the seriesColor attribute is omitted, ColdFusion automatically determines the colors of the slices.
If the seriesColor attribute is specified, ColdFusion automatically determines the colors of the slices after the first one, starting with the specified color for the first slice.

Example

<!--- The following example analyzes the salary data in the cfdocexamples
database and generates a bar chart showing average salary by department. --->

<!--- Get the raw data from the database. --->
<cfquery name="GetSalaries" datasource="cfdocexamples">
SELECT Departmt.Dept_Name, 
Employee.Dept_ID, 
Employee.Salary
FROM Departmt, Employee
WHERE Departmt.Dept_ID = Employee.Dept_ID
</cfquery>

<!--- Use a query of queries to generate a new query with --->
<!--- statistical data for each department. --->
<!--- AVG and SUM calculate statistics. --->
<!--- GROUP BY generates results for each department. --->
<cfquery dbtype = "query" name = "DataTable">
SELECT 
Dept_Name,
AVG(Salary) AS avgSal,
SUM(Salary) AS sumSal
FROM GetSalaries
GROUP BY Dept_Name
</cfquery>

<!--- Reformat the generated numbers to show only thousands. --->
<cfloop index = "i" from = "1" to = "#DataTable.RecordCount#">
<cfset DataTable.sumSal[i] = Round(DataTable.sumSal[i]/1000)*1000>
<cfset DataTable.avgSal[i] = Round(DataTable.avgSal[i]/1000)*1000>
</cfloop>

<h1>Employee Salary Analysis</h1> 
<!--- Bar graph, from Query of Queries --->
<cfchart format="flash" 
xaxistitle="Department" 
yaxistitle="Salary Average"> 

<cfchartseries type="bar" 
query="DataTable" 
itemcolumn="Dept_Name" 
valuecolumn="avgSal" />
</cfchart>

View comments in LiveDocs