When you are attempting to explain a theory or get your point across to others during a conversation, you normally will change the tone of your voice or the expression on your face.
When you have created a chart in Excel it is not always so easy to stress that important value that you want to stand out to your viewers. This tip will help make this task easier for you.
Follow the steps below to learn how:
You will most likely want to de-emphasize everything in your chart except the value that you want to stress and you can do this by:
- Right-clicking any bar in the series of your chart to select the entire series.
- Select Format Data Series from the resulting dialog box.
- On the Patterns tab, in the Area section, select a color such as light gray from the palette.
- Click OK.
Should your chart’s plot also happen to be light gray, which is the default in Excel, you will want to change that as well.
- Right-click the background and select Format Plot Area from the resulting dialog box.
- Select White from the palette.
- Click on OK.
You are now ready to emphasize a single value in your chart.
- Click the item you would like to emphasize which will select the entire series.
- Click the item one more time to select just that value.
- Right-click the item and select Format Data Point.
- On the Patterns tab, select an appropriate color to make it stand out.
- Click on OK.
The value in your chart will now have some zing to make it stand out to the viewer.