One Stacked Bar Chart to show the value of each product line as percentage of either direct or indirect sales and not of total sales as well as the total sales by channel on the chart.

How Can I Include Percentage Detail in a Revenue by Channel and Product Chart?

I promise this is my last post on the subject.  I shared my charts with the Mekko Graphics user who asked me for advice.  She liked what I did, but wanted some changes.  She wanted to show the value of each product line as percentage of either direct or indirect sales and not of total sales.  She also wanted to show the total sales by channel on the chart.  She also wanted all this in one chart.

I took up the challenge and produced the attached chart.  I had to do some manipulations in Mekko Graphics to make it work.  It is below:

 

One Stacked Bar Chart  to show the value of each product line as percentage of either direct or indirect sales and not of total sales as well as the total sales by channel on the chart.

One Stacked Bar Chart to show the value of each product line as percentage of either direct or indirect sales and not of total sales as well as the total sales by channel on the chart.

I used two tricks to create the chart.  I added data rows for total direct and indirect sales.  These were easy to compute by summing sales by product line for each channel.  I moved the data row labels and the data into the chart to make it easier to read.

Second, I used the Excel Concatenate function to create the segment labels.  I computed the percentage of channel total for each product line in a right hand column of the spreadsheet, using the Round function to eliminate the digits after the decimal point.  I then concatenated the product line name with the percentage value and a % sign to create the label.

I’ve uploaded the presentation to SlideShare: http://www.slideshare.net/MekkoGraphics/direct-and-indirect-revenue-one-chart.  You can download it to PowerPoint to see the tricks first hand.