Illustrate data tables using Excel charts

Charts are an easy way for people to easily assess your data, but you may run into trouble including data tables in your Excel form. Here's how to illustrate data tables using Excel charts.

When you want to show the data represented by your Excel chart, you could add a data table to the chart by selecting the Data Table tab in the Chart Options dialog box. However, you cannot use data tables with XY charts, pie charts, doughnut charts, radar charts, bubble charts, or surface charts. In addition, data tables' formatting options are limited compared to actual data cells.

To overcome these limitations, you can include a picture of the actual data cells in your chart. Follow these steps to insert a picture:

1. Select the data range you want to include with your chart.

2. Go to Edit | Copy.

3. Click outside the Plot Area in the Chart Area where you want to place the picture.

4. Press [Shift] and click Edit.

5. Click Paste Picture.

Note: The pasted picture is static; that is, it does not update if a change occurs in the original data range.

Miss a tip?

Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks