three columns for every Quarter), which are stacked and show the Revenue Share of the new apps within a single Division. The table in the screenshot has consolidated data that show Quarterly Revenue (Total Revenue per Quarter – columns B, C, D, E) by each Division (Productivity, Game, Utility – Rows #5, 7, 9) that includes a part of the Revenue received from the new apps (P – new apps, G – new apps, U – new apps, Rows #6, 8, 10) by each Division.įor the purpose of the data visualization, we need to show this data as several clustered columns (one column for each Division) for several Quarters (i.e. The sample data for this example was previously prepared to demonstrate the following idea: Preparing the Source Data The source data representing Quarterly Revenue by Division, including Revenue from new apps per Division

Let’s walk through the entire process from the beginning… That’s why in this article we are focusing on the most comprehensible method(in our opinion) that can be applied by regular users without difficulty. Also, every technique has its own advantages and disadvantages. However, none of them are ideal because each requires numerous additional actions and preparations related to source data or plot area, which may confuse a non-expert user. Interesting Fact: There are several other ways to combine the clustered and stacked column charts together (such as adding the legend entries, arranging the target range with blank rows and others). There are several different methods to tackle this, so let’s discuss the relatively easy (and less confusing) method: where there are several secondary chart axes using the same dynamic Min and Max values. In addition, many users – who try to combine them manually – have been confused as to how to consolidate the source data, the series and the graph axes for both charts at the same time. The difficulty may appear when we need to combine these two chart types, as Excel doesn’t give us any default, built-in tools for that.

A clustered column chart vs a stacked column chart in Excel.

Excel histogram two series