Adding a Data Table to a Chart
Data Table section of the Chart Wizard shown below allows you to display a small table of your data alongside your chart.
This can be useful if your chart is in a sheet on its own or if you want
to copy and paste your chart into a Word document but may be unnecessary if you
can see the data in your spreadsheet anyway.
If you add a Data Table to a chart with a category or automatic x-axis
it will be placed alongside the x-axis and you will not be able to format this
axis unless you remove the data table or change to a time-scale axis.
If you choose to show the legend keys in
your data table then you should remove the main legend from your chart as it
Click here to
return to the Excel index.