Creating a Stacked Column Chart

This step-by-step procedure describes how to create a stacked column chart as shown in the figure .below. In this example, the information about various qualities has been collected using a grid question as shown in the table below the chart .

Figure 1 - A Stacked Column chart

Figure 2 - Example of a Rating question

The table for this chart will be created on a new page in the report, called in this case Qualities.

Creating and Setting Up the Table

1. Create a page in the report, and on the page, create an Aggregated Table.
2. Double-click the new table object to enter the Table Designer.
3. Drag the Qualities question object from the Data Source toolbox and drop it into the cell labeled Drop Rows Here in the Table Designer view, then click the Refresh button in the toolbar.
4. Double-click the Qualities question object in the table, or right-click on the object and choose Properties.
5. Check the Collapsed checkbox and set Default Stats to Avg.
6. Click Apply and Close to apply your changes and close the Properties frame.
7. Drag a Categories object from the Table Designer toolbar and drop it into the cell labeled Drop Columns Here in the Table Designer.
8. Open the new Categories object Properties page, uncheck Totals and click Apply and Close.
9. Double-click anywhere on the table or right-click and choose Properties.
10. To display percentages (rather than counts) in the series, check Horizontal Percents.
11. If you do not wish the vertical percents to show in your final table, uncheck Vertical Percents.
12. Click Apply and Close in the Table Properties page, then click Save or OK as appropriate to return to the Page Editor for the Qualities page.
13. Click Save to save your work.

Note: You must complete this procedure before you can create the chart.

Creating and Setting Up the Chart

Note: As the chart is based on the associated table, you must create the table before you can set up the chart. See above for details.

1. On the report page, right-click in the location that you wish to add a Chart object, then go to the Insert Component > Chart command to create the chart.
2. Double-click the new Chart object, or right-click and choose Design, to open the Chart Designer page.
3. In the Report toolbox, drag the new Aggregated Table from the Qualities page and drop it into the area labeled Drop Table Here in the Chart Designer.

The Chart Designer view will automatically refresh and the table and a default chart will be displayed.

4. In the Distribution field at the top of the page, select Horizontal Percent.
5. In the Chart Style field, select Column2Dstacked.
6. Uncheck Series in rows to flip the axes.
7. Go to the Legend tab. Under the Style header select Column, under the Docking header select Lower, and under the Alignment header select Center.
8. Click OK and then Save.

Your chart should appear as below .

Note: Colors and shadings will vary depending on the template used for the report.

Figure 3 - The chart nears completion

If you would like to add border lines around the series’ bars, go to the Series tab and under Line/Border Attributes apply a style and a width. The figure below shows the result of applying those properties . Note that this also adds a border to the colored boxes in the legend.

Figure 4 - Adding a border to the bar series

If you wish to add a chart title and labels on the X and Y axes, go to the Chart Title tab and type the desired text into the Title field.

If you wish to display labels along the X and Y axes, go to the Axes tab and make the appropriate settings.

The completed chart will appear as below .

Figure 5 - The completed Stacked Column chart