in Web Intelligence

Charting in Web Intelligence – Part 6 – Column Charts

In this session lets look at Column Charts in Web Intelligence 4.1. Column Charts in 4.1 presently have seven chart types. In basic column charts, the value is represented with vertical column bars with respect to the dimension. Ideally we have one Y-axis in standard column charts but we also have variations of this chart which includes two Y-axes. Then we have combined column charts that allows Column and Line as a combination which are used to represent two related measures and its enhanced version with two Y-Axis which can be used with Column Bar on One Y-Axis and Line on the Second Y-Axis for plotting. This, in a way, gives relative independence when viewing related values whose actual values are two relatively distant sets or factors. Then we have the standard Stacked Column Chart which allows Sub-Level Dimensional Value for each Category Dimension and its 100% Stacked Column Chart which would provide additional Percentage measurement. Finally we have the 3-D Column Chart which allows a second related dimension across on Z-Axis.

Lets first look at Standard Column Chart with one and two axes below.

C1C2The Column Chart on the left shows Bars for Revenue and Number of Guests per Quarter using a basic Column Chart. As they both are on a single Y-Axis, the Number of Guests value set is small enough to not really appear as a bar in comparison to the total revenue generated as fundamentally the quantity and sales, though related, usually are different value sets. Hence, using the Column Chart with 2 Y-Axes on the right side, we have now represented them on two different Y-Axes allowing greater visibility.

Now Lets look at Combined Charts using one and two Y-Axes Column and Line Charts as shown below.

C3C4Here, we essentially show the same information using Column Bars for Revenue and Number of Guests using Lines. As is the case earlier, we observe that 2 Y-Axis Charts on the right provides independent measurement to check for any proportionality and trend which may or may not be the case based on the type of information. Single Axes flat lines the Number of Guests due to the difference in value sets in comparison to two Y-axes which is a better representation in this case.

Finally lets looks at Stacked Column Chart combinations as shown below.


On the Left we see a standard Stacked Column Chart showing Revenue for Months in each quarter. We added additional palette and colors to reflect alternative columns for Quarters. The Second Chart in the center shows both Number of Guests as Doted Lines and Revenue in Surfaces The Last Chart  on the Right shows 100% Stacked Chart with percentages for Revenue Per Month in Column Bars for each Quarter and Number of Guests for each Month per Quarter in Dotted Lines. These column charts have a default representation of Bars but they also allow use of Lines and Surfaces (shown in chart in the center) as alternative representation which in some cases saves space and groups measures into desired columns.

Column and Bar Charts have always been the first form of representation in charting and usually when we think of charts we think of column charts and in Web Intelligence these charts have been enhanced to provide comprehensive reporting and graphics with rich features set to customize the chart presentation.

Up next,  Charting in Web Intelligence – Part 7 – Version Comparisons and 3DC


Write a Comment