Column Charts in Cognos Report Studio

Column chart is a combination chart which is used to display trends in time or compare values across different categories. Column chart has Measures on Y-axis, Categories on X-axis and Series on Primary axis.

Basic Layout

 

Steps

1. Open Report Studio --> create a new report with Blank template.

 

2. Go to Toolbox menu --> Drag a Chart to the work area --> Select Column and click OK.

 

3. Drag Product Line column from Product table to the Series --> Drag Current Year column from Time Dimension to Categories -->  Drag Revenue column from Sales table to Measures.

 

4. Run the report and see the results

 

Types of Column Charts

Clustered:

Stacked:

100% Stacked:

 

Drill-Through on Column Chart

Column chart has an option to create drill-through on x-axis (Categories), Legend (Series) and on the whole chart.

 

 

Important Properties

Chart Orientation                                           

Horizontal

                                                                             

Vertical

Combinations

 

Summarize Small Items

Matrix Rows and Columns