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.
2
Replies
AdChoices