cfchart

<cfchart 
   format = "flash, jpg, png" 
   chartHeight = "integer number of pixels" 
   chartWidth = "integer number of pixels" 
   scaleFrom = "integer minimum value" 
   scaleTo = "integer maximum value" 
   showXGridlines = "yes" or "no" 
   showYGridlines = "yes" or "no" 
   gridlines = "integer number of lines" 
   seriesPlacement = "default, cluster, stacked, percent" 
   foregroundColor = "Hex value or Web color" 
   dataBackgroundColor = "Hex value or Web color" 
   showBorder = "yes" or "no" 
   font = "font name" 
   fontSize = "integer font size" 
   fontBold = "yes" or "no" 
   fontItalic = "yes" or "no" 
   labelFormat = "number, currency, percent, date" 
   xAxisTitle = "title text" 
   yAxisTitle = "title text" 
   xAxisType = "scale or category"
   yAxisType = "scale or category"
   sortXAxis = "yes/no" 
   show3D = "yes" or "no" 
   xOffset = "number between -1 and 1" 
   yOffset = "number between -1 and 1" 
   rotated = "yes/no" 
   showLegend = "yes/no" 
   tipStyle = "MouseDown, MouseOver, none"
   tipBGColor = "hex value or web color" 
   showMarkers = "yes" or "no" 
   markerSize = "integer number of pixels" 
   pieSliceStyle = "solid, sliced" 
   url = "onClick destination page" 
   name = "String"
   </cfchart>

"somepage.cfm?item=$ITEMLABEL$&series=$SERIESLABEL$&value=$VALUE$"

Comments

No screen name said on Aug 17, 2003 at 11:12 PM :

i want to solve my problem about coldfusion and learn more about it

fredvangoolen said on Sep 3, 2003 at 5:13 AM :

A nice feature would be a transparent background colour for the graph...

Symantec said on Sep 4, 2003 at 7:41 PM :

transparet background's would only be possible with png or gif due to jpg and flash not supporting them.

No screen name said on Sep 7, 2003 at 4:21 AM :

I hope the next iteration of bug fixes includes a patch to allow me to actually save the chart as claimed. I have tried 1000 different solutions to saving, displaying the variable created with name and just get garbage back.

halL said on Sep 8, 2003 at 12:48 PM :

he problem reported by No Screen Name on Sept 7 appears to be a bug and has been entered as bug number 53407.
However, there is a workaround:

Specify charset="ISO-8859-1"in the cffile tag used to write the chart to a file.

Therefore, to write a graph generated by cfchart to a file do the following:

1)Specify a name attribute, such as name="chartBuffer", in the cfchart tag

2)Use a cffile action="write" tag such as the following to write the data to a file:
<cffile charset="ISO-8859-1" output="#chartBuffer#" action="write" file="c:/temp/myChart.jpg">

(This technique works for JPG, SWF, and PNG files;
of course you must use the correct suffix in the file attribute.)

JorgeI said on Sep 20, 2003 at 8:28 AM :

It does not look like possible to chart decima values. Is this right?

halL said on Sep 22, 2003 at 7:25 AM :

ColdFusion MX can graph decimal values.

No screen name said on Sep 23, 2003 at 5:33 PM :

how can i load the type='falsh' graph into flash movie using loadMovie() method ?

LivelyHound said on Oct 1, 2003 at 4:59 AM :

The cfchart does not support a decimal x axis when the xAxisType value is set to 'scale' and the dataseries is of a 'scatter' type.
When I have tried to use this a :

java.lang.NumberFormatException: For input string: "2.29568411386593E-4"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:477)
at java.lang.Integer.valueOf(Integer.java:574)
at coldfusion.graph.Graph.getWebChartsContentXml(Graph.java:1141)

is thrown.

I have tried using the scatter type of graph and it works fine some of the time but if the x axis values have too many decimal places then the x axis resets itself to a category axis, which is no good on a scatter plot.
I have tried limiting the values by using NumberFormat() but unsurprisingly it makes no difference.

I have overcome the problem for the moment by not specifing an xAxisType and then using the x axis values for the y axis and vice versa, and then rotating the chart. This only works because the y axis values are between 0 and 1 with 2 decimal places.

jrunrandy said on Oct 1, 2003 at 6:27 AM :

This has been reported as bug/enhancement request 53505.

CJORDAN@UACCH.EDU said on Oct 8, 2003 at 7:00 AM :

HAS ANY ONE TTRIED A CHART OF A SECURE WEBPAGE i KEEP GEETING THIS PAGE CONTAINS SECURE AND UNSECURE

leontova said on Oct 13, 2003 at 1:24 PM :

Hi All. Has anyone tried to distibute data across time? The label format only shows date,currency,percent,and number. I have a query with three columns:thedate,thetime,group. I would like to get the Y range to display HH:MM:SS and AM/PM and for the Scatter plot to place a marker at each occurrance of the group associated with each time record. I have been trying for a few hours and can't get the plot to work. The CF Forums have been no help either.

Thanks for your help.
-Andy

No screen name said on Oct 15, 2003 at 1:43 PM :

We are using a DHTML menu and the CFCHART using the flash output does not allow us to configure the DHTML menu to over lay the flash output. If Macromedia has a resolution to this and we have not seen it please advise. Thanks.

jrunrandy said on Oct 17, 2003 at 8:41 AM :

This is because Flash runs as an ActiveX control, and it appears that activeX objects in the browser float above everything else, and do not honor the z-index layering of style sheets.

This has been entered as bug number 53597.

dougk said on Oct 22, 2003 at 9:01 AM :

We just discoverd this. Say your # of charts to cache is 50 and you draw a page with 75 charts, only 50 charts will display. This is because the generated object HTML tags pull the images from the disk where only 50 of them are apparently. Where the cache is stored is irrelevant it seems.

dougk said on Oct 22, 2003 at 10:06 AM :

the more I think about the above limit issue the more I am convinced this is a bug. Just because a chart is not cached shouldn't mean its not delivered to the client.

jrunrandy said on Oct 24, 2003 at 6:26 AM :

Response to CJORDAN:
Yes - when a website is set up with a certificate as a secure SSL site (https://), then IE warns whenever a page from a secure link (https://) contains links to any unsecure page (http://).

The HTML generated for <cfchart format="flash"> looks like something this:

<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://active.macromedia.com/flash2/cabs/swflash.cab#version=4,0,2,0"
ID=Images_100004_SWF name=Images_100004_SWF WIDTH=320 HEIGHT=240>
<PARAM NAME=movie VALUE="/CFIDE/GraphData.cfm?graphID=Images/100004.SWF">
<PARAM NAME=quality VALUE=high>
<PARAM NAME=bgcolor VALUE=#FFFFFF>
<EMBED src="/CFIDE/GraphData.cfm?graphID=Images/100004.SWF"
quality=high bgcolor=#FFFFFF WIDTH=320 HEIGHT=240 TYPE="application/x-shockwave-flash"
PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">
</EMBED>
</OBJECT>

IE apparently throws this warning because of the references to the plugin download locations - http://active.macromedia.com... and http://www.macromedia.com.

The actual movie - /CFIDE/GraphData.cfm - isn't a problem, since it doesn't specify either http:// or https://. This implies it comes from the same https:// site that the original page came from.

CFDaddy said on Oct 28, 2003 at 12:46 PM :

I cannot get the scale of my charts to be whole numbers if the scaleFrom is left at the default OR set to 0. Setting it to 1 makes everything look fine. The data I am displaying are whole numbers from 1 to 9, but I get a scale like this:

0, 1.125, 2.25, 3.375, 4.5, 5.625, 6.75, 7.875, and 9.

Why isn't it 0,1,2,3,4,5,6,7,8,9?

marcelomca said on Dec 4, 2003 at 4:04 AM :

CFMX 6,1 is not making graphical with decimal values. When Macromedia will decide this?

alisse said on Dec 17, 2003 at 6:23 PM :

Is there a solution for the SSL warning? I must find one.

cfGridLines (in CF exchange) will provide the correct scale-from, scale-to and no. gridlines to use for query data in conjuction with cfchart. Give it a try

DorisK said on Dec 18, 2003 at 8:13 AM :

How can I get accented characters to display properly in the chart axis labels? I've tried setting font=arialunicodeMS, but it doesn't help. I have the same problem for both JPEG and Flash output types, on a Windows server. For example, an accented e (the &eacute; character) shows up looking like a capital A with a tilde, followed by a copyright symbol.

No screen name said on Jan 12, 2004 at 11:08 AM :

'scalefrom' and 'scaleto' accepts only integer values...

Is there any other way to make it accept decimal values?
OR
Does version 6.1 tag accept decimal values?

halL said on Jan 12, 2004 at 1:10 PM :

The 6.1 tag "accepts" decimal values, but does not really honor them.
If you specify a decimal mininmum, I believe it truncates the value to get an integer.
If you specify a decimal maximum, it uses the maximum data value as the maximum.
I don't know if this behavior differs from MX.

bingo-bongo said on Jan 13, 2004 at 1:41 PM :

I need to add a title to my graphs (a la the old cfgraph title attribute). Placing a title exterior to the graph makes it very difficult to ensure that my users do not hose themselves when they copy/paste into another tool & forget to title or do not title the copy at all.

No screen name said on Jan 15, 2004 at 2:59 PM :

Does anyone have example code for using cfGridLine? I can't find documentation for it, and am having trouble getting it to work for me.

halL said on Jan 16, 2004 at 7:43 AM :

ColdFusion does not have a cfGridLine tag.
The cfgrid tag does have a gridlines="yes/no" attribute that enables row and column ruling.

No screen name said on Jan 16, 2004 at 8:08 AM :

Sorry, I meant the "cfGridlines" custom tag from the CF exchange, that Alisse mentioned earlier. I've downloaded it, but am having trouble getting it to work.

Thanks in advance!
- Sheila

hardwood said on Feb 5, 2004 at 6:41 PM :

fredvangoolen said on Sep 3, 2003 at 5:13 AM :
A nice feature would be a transparent background colour for the graph...
Symantec said on Sep 4, 2003 at 7:41 PM :
transparet background's would only be possible with png or gif due to jpg and flash not supporting them.
______________________________

If you could configure layers (Alpha, bgcolor, etc.) within the .swf (as if a file created from within flash) then this would be possible. And really nice.

jlcox said on Feb 6, 2004 at 7:58 AM :

I'm wondering about this note about changes in MX 6.1: Changed interpolation behavior: the tag now interpolates data points on line charts with multiple series.

In my experience, this is not true. If I create a graph with a two lines, one with x values of 20 and 40, and the other with x values of 10, 30, and 50, the points (markers) will be placed properly on the graph, but no lines will be drawn between them.

This is hurting me in a real-world example, where I have daily production numbers and monthly production targets. I want to graph these two on the same chart, but the monthly numbers only display as points. Is there any work-around for this besides interpolation of the monthly target numbers into daily target numbers?

No screen name said on Feb 12, 2004 at 7:02 AM :

I have two servers. In one ColdFusion with IIS and the other only IIS. I have two telephone lines. In my website(in first server) i have a coldfusion page with "cfchart", this page is out for the second server. The flash film don't load.Can you help me?

render_node said on Feb 19, 2004 at 7:02 AM :

Is there a way to have the reference to the file generated by the cfchart tag as an absolute URL? I'm trying to have the chart sent out in email and it won't display because it is a relative URL.

halL said on Feb 19, 2004 at 7:58 AM :

To write a chart to a file, use the name attribute in cfchart to save the chart to a variable and write the data to a file with cffile, as in the following example. Note that the charset="ISO-8859-1" attribute is required.

<cffile action="WRITE" file="C:/temp/mytest.jpg" output="#mydatavariable#" charset="ISO-8859-1">

No screen name said on Feb 23, 2004 at 12:36 PM :

problem font="MS Sans Serif"
not work for asia language
to display "????????????"

whyMX said on Feb 25, 2004 at 10:52 PM :

So what happened to the attributes, "labelmask", and "backgroundColor" in your documentation??

It would be good to know that the background colour can be used.

WirelessGuy said on Feb 26, 2004 at 10:41 AM :

Is it possible to have 2 y-axis using the CFCHART?

halL said on Feb 26, 2004 at 2:51 PM :

The labelmask attribute is not supported.
The backgroundcolor attribute determines the background of the entire chart.
You can use any valid chart color, either the named colors listed in the table on this page, or a hexadecimal color specification.
To specify a hex color you must use a double # sign, as in backgroundcolor="##E0E0E0".
(This is required for any hex color specification and is escapes the # sign.)

bingo-bongo said on Mar 4, 2004 at 1:54 PM :

My users used to be able to copy and paste charts/graphs from a web page into excel, word, etc....

Now that I have moved from CF5 to CF MX 6.1(on Win2K, IIS 6, IE 6), with it's associated cfchart jpg 100% cpu utilization woe, I have had to switch to flash format. And the copy/paste functionality that I used to be able to deliver is gone. My users are unhappy with me to say the least.

How do I deliver this lost functionality?

I am using Flash Player 7.
I took a peek in the Flash MX docs. If I understands the doc correctly, The ContextMenu.builtInItems(save) boolean is true by default - it has to be disabled by hand.

No screen name said on Mar 10, 2004 at 12:05 PM :

Hi
The bar chart is inflexible.For example you cannot display percentage values above each bar in a bar chart. and also is there a way to display the value of the bar above the bar or inside the bar.
Thanks,

eg8r said on Mar 17, 2004 at 9:35 AM :

I have the same question as bingo-bongo about the title. Is there no "title" attribute in cfchart?

halL said on Mar 17, 2004 at 10:14 AM :

cfchart does not have a title attribute, so you must use an external title.

Anony MX said on Mar 18, 2004 at 8:04 AM :

cfchart have a problem with
-------------------------------
font="MS Sans Serif"
-------------------------------

How to display THAI languages with cfchart?

jrunrandy said on Mar 18, 2004 at 8:37 AM :

According to this page, the allowable options for font are:
* arial
* times
* courier
* arialunicodeMS

I don't think that THAI is a supported language.

Sarge said on Mar 19, 2004 at 1:42 PM :

We are working to improve the examples in the ColdFusion reference pages. We propose to replace the current example on this page with the the following example. If you have any comments on this example, add them to this page.

The following example analyzes the salary data in the CompanyInfo database and generates a bar chart showing average salary by department. The body of the cfchartseries tag includes one cfchartdata tag to include data that is not available from the query.
<!--- Get the raw data from the database. --->
<cfquery name="GetSalaries" datasource="CompanyInfo">
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">

<cfchartdata item="Facilities" value="35000">

</cfchartseries>
</cfchart>

jladams97 said on Mar 22, 2004 at 12:08 PM :

<cfchart> and the associated <cfchartseries> and <cfchartdata> tags are wonderfully useful tags and I appreciate Macromedia providing them in CF. That said, I have 2 major problems with their implementation:

1. There is no way to format the data values used on the x axis--you can only pull them out of the query and use them as they come out. Remember, unlike the y axis, the x axis does not have to be a numeric data value--it can be any type of data value. Since there the y axis has to be numeric, the allowable formats are by definition limited and the good news is that you can set the format that you desire using the labelFormat attribute of <cfchart>. But for the x axis, you can only get what comes out of the query. In many cases, that is perfectly acceptable. However, in some cases, it is certainly not: if you're using dates, you can't put them up their in their native, unmasked format--they look terrible being followed by 00:00:00.0 or whatever it is! The only good news is that I can at least deal with this issue by taking my query results and building a new query from them, formatting my date data as I input it into the new query. But what a waste of processing that is!

2. The y axis always increases from bottom to top. You should be able to switch this behavior so that it decreases from bottom to top--the <cfchart> tag should have an attribute for this. It may initially sound weird to want lower values above higher values but if you think about it, there are lots of occasions on which you'd want this. Let's say you're graphing your golf scores--your low scores are better than your high scores and so you'll want to see them as peaks on your charts, not valleys. Ditto for rankings: rankings get better as their numeric value decreases (that is, being ranked #1 is better than being ranked #100) and you want to see #1 at the top of the y axis, not the bottom. Unfortunately, I do not believe there is a workaround for this issue (but if you know one, please tell me!)--the best I've been able to come up with is to subtract values from 0 to make them negative numbers and put those into the query I build for graphing. That makes the chart appear as desired, but the values are shown as negatives which is obviously not ideal.

gfbent said on Mar 23, 2004 at 11:37 AM :

on a chart of type "bar", because one can not, even though one would expect to be able to, add specific colors to each bar in the graph, I have added each chart data element in its own chart series. When I do this, the title and the bar do not line up and the bar becomes very narrow. Is there a way to control the bar's width? Also, is there a way in a bar chart to turn off the titles so the only thing shwoing are the bars and the grid, allowing for only the mouse over to show the chart details?

eg8r said on Mar 24, 2004 at 6:54 AM :

What happened to the attribute URLColumn? I need this so that I can bind the value from the column (bar chart) to the URL string and pass the data. For example x-axis is 12 months. User clicks on Mar, I want to be able to pass that start date of of the column.

Ed

jrunrandy said on Mar 24, 2004 at 7:16 AM :

URLColumn was an attribute in cfgraph for CF 5. CFMX and CFMX 6.1 use a different charting engine than CF 5. This charting engine doesn't support the URLColumn functionality.

Sorry.

matthewes said on Apr 6, 2004 at 8:55 PM :

As far as I can tell, Japanese only works if you set both font="arialunicodeMS" and format="flash". Thai doesn't seem to work at all.

No screen name said on Apr 19, 2004 at 12:20 PM :

So is there any way other than modifying my query to change the X axis mask? Also - what about scaling on the Y axis - shouldn't there be some sort of Log scale available for this - I am surprised that cfchart is so limited - Does anyone know of a custom tag or extension which extends the cfchart capabilities to address these issues?

halL said on Apr 20, 2004 at 7:05 AM :

There is currently no way to do a logarithmic Y scale or to format or mask X-axis data in cfchart.

Macromedia is considering enhancements to cfchart for the next release.
We have taken note of all the comments on this page and are considering the requests for inclusion in the release.

No screen name said on Apr 23, 2004 at 7:12 AM :

There is a way to place a label at the top of the series like this:
|------- [55]
|-----[40]
|-------------[60]
and is a way to make the YaxisMarkers of the gridlines INTEGER

MikerRoo said on Apr 24, 2004 at 9:35 PM :

CFChart does not seem to handle scientific notation properly.
For example, instead of 1E15, for a Y axis label, we get 1000000000000000.
Worse, this large string corrupts the layout of the plot itself.

For 2E-12, the y axis labels are omitted altogether.

Also, we really need a log scale option.

Coldfusion is great for Engineers and Scientists who want to throw their data up on the web -- That is, until we try to plot it.

Thanks,
-- MikeR

No screen name said on May 7, 2004 at 9:18 AM :

I have a query that has a percentage column. If for example the values are 33.3333333 and 66.66666666 then the bar chart looks ok, but the values on the y axis seem to lose the decimal point so that the values are very large. So the scaleto attribute does not work because the values are much bigger.

Also, with cfgraph I could use a colorlist to specify a different color for each bar, but now that's not possible unless I make one chartseries for each bar?

No screen name said on May 7, 2004 at 9:46 AM :

Maybe I'm overlooking something here.
It seems impossible to hide the labels on the x axis, as was possible with cfgraph. On the y- axis I don't seem to be able to set the number of values that are shown. A similar issue was posted earlier on this page by cfdaddy (oct 2003), but no answers. I want 2 values (the top and bottom one). With cfgraph this was easy.
You can do many things that were not possible with cfgraph but at the moment I'm not too happy with cfchart.

No screen name said on May 21, 2004 at 12:48 PM :

Ditto on both the log scale option and colorlist limitations.

singh said on Jun 3, 2004 at 10:23 PM :

HI everyone,

Is there a solution for the SSL warning?
plz help me need ASAP

singh said on Jun 4, 2004 at 8:01 AM :

Hi friends,
Unable to serve Flash content generated by cfgraph via https

Here is code u can use with cfchart also

<!--- Start saving the generated HTML output --->
<cfsavecontent variable="graph_data">
<!--- Generate the graph --->
<cfgraph type="BAR" fileformat="Flash">
<cfgraphdata item="Alpha"
value="#RandRange(1, 100)#" color="Red">
<cfgraphdata item="Beta "
value="#RandRange(1, 100)#" color="Blue">
<cfgraphdata item="Gamma"
value="#RandRange(1, 100)#" color="Green">
</cfgraph>
</cfsavecontent>
<!--- Stop saving output--->
<!--- Change the swflash.cab codebase location from
the Macromedia URL for the unsecure site to the
secure site --->
<cfset graph_data = Replace(graph_data,"http://","https://") >

<!--- Now output the graph --->
<cfoutput>#graph_data#</cfoutput>

maquejp said on Jun 7, 2004 at 7:35 AM :

I have a little problem with the CFCHART.
If works very well when I connect to the application using the intranet url
(http://myservername:port/fld1/fld2/) but when I am going through the reverse proxy to access the application from outside (https://the.reverse.proxy.name/fld1/fld2/) the organisation, it can not display the chart.
It looks like it search for https://the.reverse.proxy.name/CFIDE/GraphData.cfm?graphID=Images/100320.PNG and cannot findit.

We have some server (Development/Test/Production by application)

Anybody already got that kind of problem? Is there a fix or a workaround?

Thx!

mike.bacso said on Jul 1, 2004 at 7:23 AM :

maquejp ..

you need to make virtual directories to link your CFIDE and CFSCRIPTS dirs to the https site. Then it should work.

No screen name said on Jul 11, 2004 at 11:35 PM :

Can <cfchart> tag draw the chart with item's value??
I have read your livedocs about cfchart, but it can't show item's value directly.
It have to put your mouse on chart's item when you want to know the value.
Please help me to slove this question, Thank you :)

No screen name said on Jul 16, 2004 at 4:51 PM :

I have a CF web app that displays a page with several CFCharts which are the results of database queries. I use IE 6.

Everything works great except when I try to print it using javascript.
It prints fine when I go to File, Print..., etc
But when I try use <body onLoad="window.print(); - then they don't print out!!! There's just a blank space where they should be. Except, 1 time out of 5, they do print out??? And they display fine on the page...

onLoad is meant to wait until the entire page is loaded but I'm wondering if it is excluding the charts because they have not been received by the time it is sending the data to be printed? (the db query can take several seconds)

T
BUT, print is where the problem comes in.

pkishor said on Aug 16, 2004 at 3:11 PM :

Is it possible to specify colors (pie chart) for specific slices? I am charting 10 variables. I want var1 to be orange, var2 to be purple, var3 to be silver, etc. If all 10 vars are charted, fine. I can specify a colorList of "orange,purple,silver..." and it all works fine. Howvever, there are times when not all 10 vars are shown (vars and their values are pulled from dynamic SQL queries, and may or may not be present depending on their values and SQL params). So, for example, if only var1 and var3 are shown, I still want var1 to be orange and var3 to be silver. Except, now var1 is painted orange, but var3 is painted purple (color for var2). Is there a way to make colors stick to different vars (perhaps if the colors were pulled from a table with vars and their associated colors)?

tupa said on Aug 17, 2004 at 4:27 PM :

Is ColdFusion MX able to chart dual axis charts, that is, one chart with two Y axis ranges. (One on the left and one on the right.) and 2 X axis ranges, (One on the top and one on the bottom.)
Thanks.

JLove said on Aug 18, 2004 at 8:27 PM :

To: JRunRandy

I see that you explained to us WHY we get the SSL warning, which is due to the code that CFCHART outputs, and the fact that CFCHART does not offer a mechanism to use HTTPS links instead of HTTP. What I think we all want to know, is WHAT CAN BE DONE? THIS IS A PROBLEM! Obviously, Intranets and other sensitive web sites use SSL. These are also the types of sites that will need charts and graphs. What is the solution?

JLove said on Aug 19, 2004 at 5:27 AM :

Sorry for my last post. I found the answer to the SSL problem.

Since CFCHART uses Flash by default, and Flash is what is causing the SSL errors, you simply add format="png" or format="jpg" to your CFCHART tag and the Internet Exploder SSL secure page error goes away.

Hope that helps others.

rapcgtiac said on Sep 2, 2004 at 3:39 PM :

I created a chart using a query and the tags CFCHART and CFCHARTSERIES. But the chart will only display one data point when I want to use two data points from the query. I tried using CFCHARTDATA but it seems that tag is for data points that I define, not from the query. Is it possible to use one itemColumn attribute with two valueColumn attributes?

extdw_doc said on Sep 3, 2004 at 11:54 AM :

See the Comments sections of both the cfchartdata and cfchartseries pages for
examples (by Sarge) that use a data point from a query.

parrot person said on Sep 10, 2004 at 1:30 PM :

There's a req/opt column in the documentation for this tag, but I see none are actually filled out!

fusionps said on Sep 20, 2004 at 2:25 PM :

I have a page with about 10 charts. Whenever I try to copy and paste the page into MS Word document, I get a message saying 'Image expired. Refresh the page to view the image'. Has anybody had a similar problem? I tried to setting different options on the CFAdmin but still having same problem.

bridgefun said on Oct 1, 2004 at 9:33 AM :

It is very frustrated that there is no way to make chart Y-Axis lable show just integer, rather than 1.111..... I want the scale only show 0, 1, 2, 3, ... can someone let me know how to define it.

MikerRoo said on Oct 14, 2004 at 11:49 PM :

The SSL issue with flash charts needs to be fixed. Please enter a bug for this.
We are using Singh's workaround but the overhead is really bogging down our app.

In fact, we should have the option to turn off the "codebase" and "PLUGINSPAGE" strings altogether (by setting a parameter for cfchart).

These strings seem unnecessary after the user's first flash object (If then) and they are using 180 bytes for each chart. (Over 5K on one of our pages!)

Thank you.

Balance said on Oct 18, 2004 at 12:59 PM :

cfchart is "hanging" for one of my sites. I've added the CFIDE virtual directory and have modified the neo-graphing and web XML files per Brandon Purcell's suggestion, but cfchart still hangs. Is there a workaround? Can I serve it through cfcontent? If so, how?

MikerRoo said on Oct 19, 2004 at 12:02 AM :

To Balance,

I have had a whole host of similar problems and have a workaround that (so far) is satisfactory... Bypass GraphData.cfm altogether.


Map a web directory (Allow Get only) to the chart caching folder.
For example, on my servers, I mapped
"chartcache/"
to the server folder:
"C:\CFusionMX\charting\cache"

Then, following an approach similar to Singh's solution, above.

Here's a code snippet from my plotting object. This works with all three chart types and handles the flash SSL bug.
It also seems faster!

*** Note this code is inside a <CFOUTPUT> tag ...

<!--- Save CFCHART's generated HTML, so that we can apply all the needed fixes. --->
<CFSAVECONTENT variable="sGraphObjectText">
<CFCHART
*** Chart generating stuff here ***
</CFCHART>
</CFSAVECONTENT>


<!--- Attempt to fix CFM's chart caching. Approach one. Use files that were not deleted.
| CFM "expires" the image but doesn't delete the files! Bypass GraphData.cfm it's AFU.
|
| Note that "chartcache/" is a mapped web directory to C:\CFusionMX\charting\cache.
| Also, we will have to clean up the cache dir, via a chron job, but the directory was filling up anyway!
|
| Oct, 15: It works! Printed several hundred charts on one page with no "expired images"!
--->
<CFSET sGraphObjectText = Replace (sGraphObjectText, "CFIDE/GraphData.cfm?graphID=Images/", "chartcache/", "all") >

<CFIF bUseSSL_Fix>
<!--- Correct CFM's two bogus embedded flash links. --->
<CFSET sGraphObjectText = Replace (sGraphObjectText, "http://", "https://", "all") >
</CFIF>

<!--- Now output the graph object text. --->
#sGraphObjectText#

You may have to alter the first replace-text to match the XML changes that you did.

Good Luck!
-- MikeR

Balance said on Oct 19, 2004 at 6:35 AM :

MikeR, thanks a lot for your input! I may eventually have to use your solution.

However, I was able to fix this problem (for now at least) by configuring IIS with CFMX per this article (http://livedocs.macromedia.com/coldfusion/6/Installing_ColdFusion_MX/configuring4.htm#1118876). Turns out that when I created this new site the JRunScripts VD was not created automatically (it was created for the other 4-5 sites, though). It also appears that when I uploaded this server with the most recent .NET framework that's when it stopped creating the JRunScripts virtual directory on the fly. Can MM comment on this?

Balance said on Oct 19, 2004 at 6:37 AM :

Had a typo in there.

This: It also appears that when I uploaded this server with the most...

Should be: It also appears that when I *updated* this server with the most...

No screen name said on Oct 19, 2004 at 11:33 AM :

I have seen my problem asked several times on this page, perhaps there is no way to do it. Would be nice to know if it is impossible.

Again, all I need to know is how to display the values on the columns, or pie slices themselves within the graphic. Someone showed it like this:

|------- [55]
|-----[40]
|-------------[60]

I can't believe this is not able to be done in this tag.

MikerRoo said on Oct 19, 2004 at 4:32 PM :

I will say it. Showing the value, for each point/slice/bar, statically -- seems to be impossible. If you set the tip style to "Mouseover", cfchart will do a good job of showing these values on rollover only. This really only works well for the flash image type -- but it's been good enough for my customers.

It should be possible to write your own data-point labels by associating floating divs with each map area (when using the png or jpg type) but this seems to require some pretty fancy DHTML and I'll switch to another graphics package before I attempt it.

No screen name said on Oct 20, 2004 at 1:28 AM :

Does anyone know if it's possible to set the formatting of a chart using stylesheets? Thanks.

ford0067 said on Oct 22, 2004 at 2:03 PM :

Does anyone have an answer to tupa's question dated Aug 17th. My company is also exploring the ability to do a dual Y axis chart and I am curious if this is possible.

godardk said on Nov 1, 2004 at 8:21 AM :

fusionps - is your server load-balanced with another one? If so, see this technote: http://www.macromedia.com/support/coldfusion/ts/documents/cfchart_cluster.htm

BenRJ said on Nov 4, 2004 at 8:38 AM :

We recently upgraded to the Sun JVM version 1.5 and now CFCHART doesn't work.. It throws this error:
No X11 DISPLAY variable was set, but this program performed an operation which requires it. null

Our servers are all Red Hat Linux with CFMX and the most recent Updater.

Anyone have a clue?

rxeno said on Nov 5, 2004 at 12:15 PM :

It could be because
ColdFusion MX: Using cfchart or other graphics rendering objects on Unix platforms with JVM 1.4.1 or higher
found this at.....
http://dynamic.macromedia.com/support/coldfusion/ts/documents/graphics_unix_141jvm.htm

rxeno said on Nov 5, 2004 at 12:22 PM :

My query returns more than one result for a field, how can I show both grouped by date . The docs say only the last will be displayed???

fusionps said on Nov 10, 2004 at 2:24 PM :

To godardk,
Thanks for your response. Our server is not clustered. My problem was caused by the CF chart caching problem. I implemented MikeR's solution above and my charts are now working great. This problem should be included in the bug report if it's not already.

No screen name said on Nov 18, 2004 at 3:13 PM :

when the decimal number is greater then 10000 I get an error
<cfchart format="flash" showygridlines="Yes">
<cfchartseries type="curve">
<cfchartdata item="18/11/04 01:00" value="10000,5">
<cfchartdata item="18/11/04 02:00" value="10000,3">
</cfchartseries>
</cfchart>
Error:The value of the attribute VALUE is invalid. The value cannot be converted to a numeric because it is not a simple value.Simple values are booleans, numbers, strings, and date-time values.

B_Cooper said on Nov 29, 2004 at 11:01 AM :

Y axis labels...I want to set them and not have them vary according to the data set. The customer wants the to read 25, 50, 75, 100 for a report displaying percentages. Ideas? Thanks!

B_Cooper said on Nov 30, 2004 at 4:10 PM :

Bar chart colour has been set in the cfchartseries tag and works as long as the query returns more than one record. If it returns a single record it changes the colour to gold. It looks like we are highlighting some areas when actually want them all the same colour. Ideas?

No screen name said on Dec 8, 2004 at 8:19 PM :

So is macromedia ever going to chart decimal values?

No screen name said on Dec 10, 2004 at 3:51 PM :

Decimals are graphed just make sure that there is no space in the value exampl value=" 80.25" is incorrect while value="80.25" is correct.

WhazzInAName said on Dec 31, 2004 at 9:51 AM :

Hi All !

I have a problem with creating two different chart series that have the same range of x and y data but different values on the x and y axis. Cfchart seems to plot them in different chart areas instead of overlapping them in the same area.

This problems has been documented in another post on the web which I am reproducing below and which explains my dilemma....

http://forums.devshed.com/t78276/s.html?highlight=power+series+development

[quote]

I'm trying to create a graph with two different chart series over top of each other. The problem that I'm running into is that each chart series is unrelated to the other. The only thing they have in common is the ranges of the x and y data. In this case, the x's fall in between 20 and 100 and y's fall in between 70.000 and 390.000.

Here's a sample of my data:

Series 1 (x,y)
----------
25, 99.357
31, 123.697
43, 163.415
52, 194.176
74, 314.805
87, 366.572

Series 2 (x,y)
----------
20, 74.311
25, 93.765
30, 113.589
35, 133.794
40, 154.391
45, 175.391
50, 196.807
55, 218.652
60, 240.937
65, 263.676
70, 286.884
75, 310.576
80, 334.765
85, 359.469
90, 384.704

What I'm finding is that Cold Fusion will actually display the series side-by-side instead of overlapping. It SEEMS that unless the "item" attribute of the <cfchartdata> tags line up in the different series, then the graph won't display the series as overlapping, but rather side by side.

Here is the code I'm using...
<cfchart>
<cfchartseries type="scatter">
<cfchartdata item="25" value="99.357">
<cfchartdata item="31" value="123.697">
<cfchartdata item="43" value="163.415">
<cfchartdata item="52" value="194.176">
<cfchartdata item="74" value="314.805">
<cfchartdata item="87" value="366.572">
</cfchartseries>

<cfchartseries type="curve">
<cfloop index="i" from="20" to="90" step="5">
<cfchartdata item="#i#" value="#i / ( 0.27919 + ( -0.0005027 * i ) )#">
</cfloop>
</cfchartseries>
</cfchart>

[quote]

Has anyone encountered this problem and does anyone have a workaround over this.
Any help would be greatly appreciated !

Thanks a bunch :)

Harry

ASandstrom said on Jan 5, 2005 at 7:51 AM :

To avoid the problem described by WhazzInAName, use the sortXAxis attribute of the cfchart tag, and set the value to yes, for example <cfchart sortXAxis="yes">.

mitchiru___jo said on Jan 13, 2005 at 2:03 AM :

this tag is still disastrous. even php provides better chart-functions!

No screen name said on Jan 17, 2005 at 3:45 PM :

We would also like an efficient way to have our dhtml menu over lay the Flash cfchart! Please consider this for Blackstone (if it isn't already too late)!

Dave (newbie) said on Feb 7, 2005 at 12:11 PM :

I was wondering if Blackstone has/will have the capability of doing Log Scaling on the Y axis? Or if this is still a desired function of the CFChart tag? Really need this to produce the desired charts for my reports. Thanks

gareth_cole said on Feb 9, 2005 at 7:05 PM :

The xaxistype="scale" attribute is useful for plotting coordinate data.
Unfortunately, the scaleto and gridlines attributes only apply to the y-axis. I need similar attributes for the x-axis as the default scaling of the x-axis is messy.
Will this be fixed in CFMX7?

Joe S. said on Feb 21, 2005 at 7:20 PM :

For some reason CFCHART keeps using decimals ... Tried using the rounding technique displayed here but it does not want to round the numbers. Anyone else having this issue?

cgsj_usa@yahoo.com said on Feb 28, 2005 at 7:52 AM :

Up until today, cfchart was working beautifully in my applications. Now, whenever I use it to try and display, I only get the dredded Red x that denotes the image can't be found. Any idea why this behaviour would just start happening, out of the blue? Please send your comments to cgsj_usa@yahoo.com. Thanks.

Chris

Mancho00 said on Feb 28, 2005 at 11:07 AM :

I still haven't seen any response about whether interpolation actually works. I haven't been able to get it to work at all. Is there a special case that you have to use to get it to interpolate points between series?

csecord said on Mar 1, 2005 at 8:41 AM :

<i> Joe S. said on Feb 21, 2005 at 7:20 PM : For some reason CFCHART keeps using decimals</i>

Find the max value that will be displayed on the chart, and pass it to this function:

function cfChartScaleTo(MaxDataValue) {
return ((MaxDataValue \ YAxisTicNum) + MaxDataValue mod YAxisTicNum) * YAxisTicNum;
}

You can then use the result of the function as the ScaleTo parameter to cfChart. Works for me every time.

csecord said on Mar 3, 2005 at 8:37 AM :

oops, there is an error in the comment I posted yesterday! Try this instead:

function cfChartScaleTo(MaxDataValue) {
return ((MaxDataValue \ YAxisTicNum) + 1) * YAxisTicNum;
}


I also should have mentioned that YAxisTicNum is a global constant you'll have to set. It is the number of tics on the Y axis of a cfchart. Normally, there are 9 tics on the chart, so the function returns a ScaleTo number that is always divisible by 9. If the labels on your X axis are very large though, cfchart will use less tics. So, you have to call cfchart once and see what number it picks and then set YAxisTicNum to that.

cvleon said on Mar 8, 2005 at 7:33 AM :

It's possible to set the Legend location if you create your own style (as per http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?href=00001431.htm&single=true )

I've added placement="right" to the <legend> tag in my style.xml file, and now the legend always appear to the right of my graph.

Robget said on Mar 9, 2005 at 8:26 AM :

<i> Joe S. said on Feb 21, 2005 at 7:20 PM : For some reason CFCHART keeps using decimals</i>

A simpler method you might try, along the same lines is by adding a gridlines tag with the following variable to your CFChart tag

<cfset gl=(YourMaxRecords / 10)-1>
gridlines="#gl#"

No screen name said on Apr 8, 2005 at 6:43 PM :

I have a problem where my chart is displayed properly on my development server which is a Windows XP system, however, when I try to display the chart on my production server the page seems to hang and only shows a blank square where the chart should be. If I change the chart type to JPG, I get the little red X icon.

I have checked the virtual directories and they are identical, I have also checked the versions of CFMX and they are both 6,1,0,63958 Enterprise. Just to be sure, I tried it on a Windows 2003 server and had the same problem.

Any ideas on what is going on here? Thanks. -rookk-kdr

prayank said on Apr 10, 2005 at 9:13 PM :

Your charts might be timing out on the production server. Have you checked if the datasources that you are using are accessible from the production server?

If yes, then check that the response time from the data sources is same for the development and production servers.

Prayank

John2 said on Apr 26, 2005 at 9:22 AM :

cfchart has been working fine on our 2003 environment and then suddenly it has stopped :(

the graphs are being created in the cache BUT the graph does not load it just sits there waiting to load.... can any one shed some light on why this may have happened? its cfmx 6.1 standard

HELP !!!

John2 said on Apr 27, 2005 at 5:16 AM :

update - i can create jpg graphs - but not flash graphs they just sit there loading.... any ideas ??

Acronumb said on May 2, 2005 at 1:39 PM :

If you know the maximum Y-value of your chart (maxchartvalue), you can control your y-axis label increment as well as the number of grid lines follows.

<cfset #increment# = 50>
<cfset #numgridlines# = #ceiling(maxchartvalue/increment)# + 1>
<cfset #scaleto# = (#gridlines# - 1) * #increment#>

Then set these attributes in your cfchart:

gridlines="#numgridlineS#"
scale="#scaleto#"

Acronumb said on May 2, 2005 at 1:42 PM :

Correction to previous entry:

<cfset #increment# = 50>
<cfset #numgridlines# = #ceiling(maxchartvalue/increment)# + 1>
<cfset #scaleto# = (#numgridlines# - 1) * #increment#>

No screen name said on May 5, 2005 at 2:18 PM :

when creating a rotated 3d flash chart , the xAxis labels seem to be upside down. Any way to fix this?

<CFCHART
chartwidth="660"
chartheight="800"
gridlines="20"
xaxistitle="Date"
yaxistitle="Value"
showBorder="no"
labelFormat="number"
format="flash"
sortXAxis="no"
rotated="yes"
show3D="yes"
markerSize="3">

No screen name said on Jul 11, 2005 at 11:53 AM :

Is there a bug on placing a line graph series with a bar graph series? It seems that the bar graph forces all other graphs to be spaces out rather than one on top of one another. However if I change the bar graph to an area chart, the spacing is correct. Here is my example of three straight lines across the top of an ara chart:

<cfchart
xAxisTitle = "Division"
yAxisTitle = "#ThisReport[i][3]#"
format = "flash"
chartHeight = "300"
chartWidth = "400"
scaleTo = "100"
gridlines = "11"
markerSize="1">
<cfchartseries
type="line"
seriesLabel="Comparative data"
seriesColor="blue">
<cfloop from=1 to="#arraylen(DivisionArray)#" index="k" step="1">
<cfchartdata item="#DivisionArray[k][3]#" value="#ThisReport[i][5]#">
</cfloop>
</cfchartseries>
<cfchartseries
type="line"
seriesLabel="Annual Goal"
seriesColor="##06FF00">
<cfloop from=1 to="#arraylen(DivisionArray)#" index="k" step="1">
<cfchartdata item="#DivisionArray[k][3]#" value="#ThisReport[i][6]#">
</cfloop>
</cfchartseries>
<cfchartseries
type="line"
seriesLabel="Minimal Acceptable"
seriesColor="yellow">
<cfloop from=1 to="#arraylen(DivisionArray)#" index="k" step="1">
<cfchartdata item="#DivisionArray[k][3]#" value="#ThisReport[i][7]#">
</cfloop>
</cfchartseries>
<cfchartseries
type="area"
seriesLabel="Divisions"
seriesColor="#strColor#">
<cfloop from=1 to="#arraylen(DivisionArray)#" index="k" step="1">
<cfchartdata item="#DivisionArray[k][3]#" value="#DivisionArray[k][2]#">
</cfloop>
</cfchartseries>
</cfchart>


I would rather have the area chart be a bar chart, but the spacing just throws it off.

No screen name said on Jul 11, 2005 at 11:57 AM :

nevermind, I just saw the post about the sortXAxis = "yes/no". This fixed it.

rohan_baweja said on Sep 16, 2005 at 6:36 AM :

Has someone else faced Slow plots using <cfchart>? I created a line graph using data from a query and then plotting it with <cfchartdata>. The number of plots ranges from 300-3000 points. I have checked the query to see if thats what is making it slow but its not that. It only takes close to 300ms to spit out data to the charting code. However the charting takes about 60+secs to show a line or curve. Does anyone have a solution to this?

Boberto said on Nov 21, 2005 at 7:39 AM :

Here is a fix for the SSL security warning issue

<cfsavecontent variable="test">
<cfchart format="flash" chartheight="100" chartwidth="100" showygridlines="no" seriesplacement="default" labelformat="number" showlegend="no" tipstyle="mouseOver" pieslicestyle="solid">
<cfchartseries type="pie" query="mathCal" itemcolumn="label" valuecolumn="num" serieslabel="test"></cfchartseries>
</cfchart>
</cfsavecontent>
#replacenocase(test, "http:", "https:", "ALL")#

No screen name said on Jul 28, 2006 at 11:29 AM :

Possible solution to odd scale values in gridlines. I found that if I added one more gridline than I thought necessary, then the values came out correct. For example, if the scalefrom=0 and scaleto=2000, i would have thought 20 gridlines would give me scale values of 100, 200, 300, etc... Not the case. However, 21 gridlines did give me the right scale.

aclark_ said on Jun 7, 2007 at 7:50 AM :

I fixed the ssl warning issue by doing this:

- Stop coldfusion
- backup file webcharts3D.xml
- Edit webcharts3D.xml - replace http://active.macromedia.com with https://download.macromedia.com
- start coldfusion

note:
webcharts3D.xml is located in
C:\CFusionMX7ib or C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusionib

I haven't seen any ill effects... so far :P