Skip to main content
  1. Tech
  2. Gadgets & Tech
  3. Tech Gear

Excel Tip: How to Display Data Labels on a Microsoft Excel Chart

See also

Microsoft Excel charts are a great way to display data in a visual fashion. When there are a lot of data, the information can be overwhelming and difficult to determine values. Display data labels and Excel charts become crystal clear.

Microsoft Excel charts can often be difficult to read. When numbers are close in range, it can make it impossible to determine the difference between numbers. Display data labels on an Excel chart and the information becomes very clear.

Follow these steps to add data labels to the chart.

Excel 2003 (and earlier):

Simply right-click on the data and select "Format Data Series" from the shortcut window.

In the "Format Data Series" window, click on the "Data Labels" tab.

Select the "Values" check-box and press the "OK" button to save the changes and close the window.

Excel 2007:

Right-click on the data and select "Format Data Labels" from the shortcut window.

Select the "Value" check-box on the "Label Options" tab.

Press the "OK" button to save the changes and close the window.

Adding the data labels on an Excel chart now allows for a clear view of all data.

For those not familiar with charts in Excel, here are quick instructions on adding charts.

Excel 2003 (and earlier):

Place the cursor in any cell within the data you wish to use for the chart.

Click on the "Insert" menu and select the "Chart" option.

The "Chart Wizard" opens. Following the instructions on the screen, make the selections you want and continue to the next screen by pressing the "Next" button.

Once the chart is created, you may follow the steps above to add data labels to the chart.

HINT: Within the "Chart Wizard," click on the "Data Labels" tab on Step 3 to select "Values." Doing this displays the data labels prior to the creation of the chart and there is no need for using the steps described above.

Excel 2007:

Place the cursor in any cell within the data you wish to use for the chart.

Click on the "Insert" tab and select the chart type of your choice in the "Chart" group.

The chart is created and you may follow the steps above to add data labels.

I hope this Excel Tip helps create easy to read charts.

To read more Excel Tips like this one, SUBSCRIBE to my Phoenix Technology Tips Examiner page.

Advertisement

Don't Miss

  • Unity
    'Assassin's Creed Unity' preview: Ubisoft comes home to its urban origins
    Games Preview
  • Smart vending machine
    This smart vending machine will recommend drinks for you based on your gender and age
    Video
    Tech Buzz
  • Destiny
    The 'Destiny' beta: 7 things we absolutely love about Bungie's new franchise
    Games Feature
  • Wi-Fi
    Find out how to stretch your Wi-Fi signal where it has never gone before
    Tech Tips
  • Far Cry
    'Far Cry 4' exclusive: Animals, avalanches, oxygen, side content and much more
    Games Interview
  • Gamer ghost
    Gamer finds and plays with ghost of deceased father on a classic game
    Video
    Headlines