Competition chart with residual data

When analyzing or presenting data in comparison or competitive charts, it is useful to see the points scored or results achieved and the remaining points to complete the Goal. For example, you can easily create a simple competition chart with residual data:

Creating a simple competition chart

Competition is an integral part of the development of any company and community. From childhood, we compete for our favorite toys among peers, for leadership in games, and so on. Healthy competition helps to achieve many goals: from quickly solving problems to choosing the most appropriate strategy.

Protect Excel spreadsheet options

To protect your spreadsheet, Excel proposes the following options:

Show chart data in hidden cells

Excel allows you to create charts and diagrams from different data sets, even those that contain hidden or empty cells. However, sometimes you may see unexpected results. For example, if there are hidden cells in the chart data, by default, Excel ignores such data and doesn't display the corresponding chart elements. You can easily force Excel to handle hidden data.

How to make Tornado chart in Excel

The tornado chart is a modified version of bar charts with two columns of data series whose bars are horizontal and pointing in opposite directions, with the base in the middle of the chart. In fact, the only difference between the tornado chart and the very similar charts - the butterfly chart and the mirror chart - is that the data series used to create the tornado chart must be sorted from the largest to the smallest.

How to create interactive chart with dropdown list in Excel

Excel offers various controls that can be useful for creating an interactive, uncluttered chart with lots of data series. One useful control is the Combo Box, which creates a normal dropdown list with possible alternative chart data series.

Progressively create a Gantt chart in Excel

A Gantt chart is one of the most popular tools in project management. It illustrates project schedules by showing activities, like tasks and events, against time.

Unrealized Gain and Loss

For the analysis of the investment portfolio, it is helpful to see the unrealized gain or loss. These amounts show how many you will receive or lose if you realize all available stocks right now. Sure, there are some fees for the operations that can decrease gain or increase loss, but, at least, you want to see the least approximate amounts:

How to highlight a data point

One of the essential parts of any work with data is presenting results. You can use many different charts, diagrams in Microsoft Excel or PowerPoint.

How to create Butterfly chart in Excel

A butterfly chart is a simplified version of a diverging chart, also known as a divergent chart. Unlike a diverging chart, a butterfly chart can only compare two data sets using two horizontal bars with a central baseline.