How to Format Chart Data in Excel
One way to emphasize chart data is to change the formatting of a specific piece of data or a data series so it stands out from the rest of the chart.
You can make a data series stand out by applying a different color to the series.
Right-click a data series and select Format Data Series from the contextual menu.
The formatting pane appears at the right.
The formatting is applied to the entire data series.
You can also switch the chart element you want to format from right within the formatting panel.