Competition chart with residual data

For some presentation of the competition will be more informative to see points that missed to achieve the Goal. This tip is about how to create simple competition chart with residual data.
The Competition Chart Excel 2013

To create the chart like this one, do the following:

1. Add additional data to you chart to see the residual data (in this example, cells C16:D16 ):

2. Select all necessary data - in this example, C4:D4, C15:D16 :

Data Competition Chart Excel 2013

3. On the Insert tab, in the Charts group, choose the Bar button:

Bar Charts in Excel 2013

Choose 100% Stacked Bar :

100% Stacked Bar Charts in Excel 2013

4. Right-click on second series and in the popup menu select Add Data Label and again Add Data Label :

Add Data Label in Excel 2013

Many thanks megaicons.net for funny icons.

Make any other adjustments to get the look you desire. See more:

Transactions Tracking

  • Income
  • Expense
  • Transfer
  • Buy,Sell and Dividend
Track your finances at https://moneybench.net Try Now

Quick Overview

  • Income and Expenses
  • Assets and Liabilities
  • Investments
  • Net worth
Track your finances at https://moneybench.net Try Now

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.