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:
Copy the source data for the chart.
Select the chart.
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.)
Size and position the picture of the source data.
In the formula bar, type a reference ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
