Dennis Faas's picture

Illustrate Data Tables Using MS Excel

When you want to show the data represented by your Excel chart, you can add a data table to the chart by selecting the Data Table tab in the Chart Options dialog box. You cannot though, use data tables with XY charts, pie charts, doughnut charts, ... radar charts, bubble charts, or surface charts. Data tables' formatting options are also limited compared to actual data cells. To overcome these limitations, you can include a picture of the actual data cells in your chart. Follow the steps below to insert a picture: Select the data range you want to include with your chart. Click to Edit | Copy. ... (view more)

Subscribe to RSS - charts