-
1. Re: Stacked Bar Chart Issue
berniemiller Apr 2, 2012 11:17 AM (in response to berniemiller)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.
-
2. Re: Stacked Bar Chart Issue
berniemiller Apr 3, 2012 5:40 AM (in response to berniemiller)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>
-
3. Re: Stacked Bar Chart Issue
BKBK Apr 13, 2012 8:02 AM (in response to berniemiller)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!