Skip to main content
Inspiring
March 5, 2009
Question

xml and cfchart

  • March 5, 2009
  • 2 replies
  • 482 views
I have a cfchart with two series, one bar (total count for a period) and one line (average count for a period) I want to add a third series, anohter bar (total dollar for a period). The problem is that the dollar amount greatly exceeds the other two series in the y axis, makes them appear as if they did not exists at all.

So what I am doing now is using xml to create a second y axis for the dollar amount, Here is what I have so far :

<?xml version="1.0" encoding="UTF-8"?>
<frameChart is3d="false" >
<yAxis scaleMin="0" scaleMax="150" labelCount="10">
<labelStyle color="black" orientation="horizontal"/>
</yAxis>
<xAxis>
<labelStyle color="black" orientation="slanted"/>
</xAxis>
<elements place="Default" shape="bar" drawShadow="false">
<series index="2" shape="bar" isSecondAxis="true"/>
</elements>
</frameChart>

Here are the problems I am running into :
the bar for the dollar amount is stacked on top of the bar for the count, I want them side by side.
The series for the line (average count) is ok but it is now behind the bars, it used to be in front of the bars.
The scale for the original y axis is now in decimals, 10, 12.5, 16.8...etc, it used to be just whole numbers
The border around the chart and the 2nd y axis is blue, I do not know how to make it black
Is there a way to display the actual value/datapoint of the dollar only, on top of the bar ?

Anyone with xml experience that can help ? also, what is a good resource on the net that will have all the tags I am looking for ? right now, I am just getting them piece by piece and putting it together.
    This topic has been closed for replies.

    2 replies

    Inspiring
    March 6, 2009
    sorry, the file is webcharts.bat, not webcharts3d.bat

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/
    Inspiring
    March 6, 2009
    start webcharts3d, which comes with cf (can be found in:
    {cf_install_dir}\charting\webcharts3d.bat)

    enter some sample values to generate the chart you want.
    change various options to make it look the way you want.
    view the chart's XML, copy/save it and use it in your real chart.

    Azadi Saryev
    Sabai-dee.com
    http://www.sabai-dee.com/