Click here for great value web hosting.

ALL ABOUT OFFICE

HOME

ACCESS

EXCEL

WORD

OUTLOOK

POWERPOINT




Search for
 

help


EXCEL

Adding a Data Table to a Chart

The 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 becomes redundant.

Click here to return to the Excel index.

webmaster@allaboutoffice.co.uk