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.
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:
3. On the Insert tab, in the Charts group, choose the
Bar button:
Choose 100% Stacked Bar:
4. Right-click on second series and in the popup menu select Add Data
Label and again Add Data Label:
Make any other adjustments to get the look you desire. See more:
Please, disable AdBlock and reload the page to continue
Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.