O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Data Tables

You can add a data table to a chart by selecting the chart, choosing Chart, Chart Options, clicking the Data Table tab, and selecting Show Data Table. The resulting data table shows the numbers from which the chart was derived and is particularly useful when the chart is located on a separate chart sheet.

Unfortunately, you can't move or format the data table. You can create a more flexible equivalent to the Data Table option as follows:

  1. Copy the source data for the chart.

  2. Select the chart.

  3. Hold down the Shift key and choose Edit, Paste Picture. (The Paste Picture command does not appear on the Edit menu unless you hold down the Shift key.)

  4. Size and position the picture of the source data.

  5. In the formula bar, type a reference ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required