Skip navigation

Reporting

Currently Being Moderated

Stacked Bar Chart Issue

Mar 22, 2012 7:55 AM

Tags: #chart #bar #stacked

Hello, with ColdFusion 8 this code produces duplicate stacked bars. The two chartseries are required to produce the stacked affect. One bar stack is labeled "Programs" and the second is labeled "Enrolled Programs". They are identical and both contain the data I wish to display so obviously I only want one of them. Suggestions? Thanks.

<cfchart format="flash" showlegend="yes"

chartheight="350"

chartwidth="350"

showxgridlines="no"

showygridlines="no"

showborder="no"

fontsize="12"

fontbold="no"

fontitalic="no"

xaxistitle=""

yaxistitle="Count"

show3d="yes"

rotated="no"

sortxaxis="no"

showmarkers="yes" seriesplacement="stacked">

<cfchartseries type="bar" query="qAllProgramsCount" seriescolor="blue" itemcolumn="title" valuecolumn="prgCount" serieslabel="Programs" >

<cfchartseries type="bar" query="qEnrolled" seriescolor="red" itemcolumn="title" valuecolumn="prgCount" serieslabel="Enrolled Programs" >

</cfchart>

1278 Views 3 Replies Latest reply: BKBK, Apr 13, 2012 8:02 AM

Replies

Currently Being Moderated

1. berniemiller,

Apr 2, 2012 11:17 AM in reply to berniemiller

Report

It never fails that as soon as I post a question I figure it out...anyway, it was differenciating on the "title" in my two queries. I made them the same and viola, one bar! Hope this helps someone.

|
Mark as:
Currently Being Moderated

2. berniemiller,

Apr 3, 2012 5:40 AM in reply to berniemiller

Report

I also figured out that the query data must be arranged in columns not rows. At first I had the values for each stack piece on a separate row. This would work for a single bar but adding multiple bars would just duplicate the first. The trick was each bar should be a single row with each piece of the stack a separate column. Once I put the survey response counts into columns I could feed the query into the chartseries like so and I got the desired stacked bar chart for each subquestion.

<cfchartseries type="bar" query="qChartData" seriescolor="red" itemcolumn="subquestion" valuecolumn="disagree" serieslabel="Disagree" > </cfchartseries>
<cfchartseries type="bar" query="qChartData" seriescolor="yellow" itemcolumn="subquestion" valuecolumn="somewhatagree" serieslabel="Somewhat Agree"></cfchartseries>
<cfchartseries type="bar" query="qChartData" seriescolor="green" itemcolumn="subquestion" valuecolumn="agree" serieslabel="Agree" ></cfchartseries>
<cfchartseries type="bar" query="qChartData" seriescolor="blue" itemcolumn="subquestion" valuecolumn="stronglyagree" serieslabel="Strongly Agree" ></cfchartseries>

|
Mark as:
Currently Being Moderated

3. BKBK,

Apr 13, 2012 8:02 AM in reply to berniemiller

Report

berniemiller wrote:

It never fails that as soon as I post a question I figure it out...anyway, it was differenciating on the "title" in my two queries. I made them the same and viola, one bar! Hope this helps someone.
It surely will, if you mark the question as answered!

|
Mark as:

Forum guidelines

Answers + Points = Status

10 points awarded for Correct Answers
5 points awarded for Helpful Answers
10,000+ points
1,001-10,000 points
501-1,000 points
5-500 points