How to highlight a data point

Excel 365
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.

One of the informative methods is highlighting specific data points:

Chart with highlighted data points in Excel 2016

The main idea of how to show this data in different colors is to create separate data series for different colors.

To create a chart like one above, follow the next steps:

   1.   Split your data by color:

  • In red will be shown the minimum value:

    = IF (cell = MIN (<data range>), cell, 0)

  • In green will be shown the maximum value:

    = IF (cell = MAX (<data range>), cell, 0)

  • In grey will be shown all the other values.

For example (here <data range> = $C$3:$C$6):

Data for the chart in Excel 2016

   2.   Select the data cells (in this example, B3:B6, E3:G6).

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

Column Charts in Excel 2016

Choose the Stacked Column Stacked Column Charts in Excel 2016 chart.

Make any other adjustments to get the look you need.

Stacked Column chart in Excel 2016

To add data label for just one data point, do the following:

   1.   Right-click on any data series (in this example, the maximum value) and choose Add Data Labels -> Add Data Labels in the popup menu:

Add Data Label in Excel 2016

   2.   Right-click on the added data labels and choose Format Data Labels... in the popup menu:

Format Data Labels in popup menu Excel 2016

   3.   On the Format Data Labels pane, in the Label Options tab, in the Numbers group:

  • In the Category drop-down list, select Custom,
  • In the Format Code field, type the new format for labels:

    <format for the positive value>; <format for the negative value>; <format for the zero>:

    Format Data Labels in Excel 365

    To skip the negative values and zero, just leave them empty.

  • Click Add.

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.