Inside Microsoft Office

View your chart and its underlying data simultaneously (2000/2002/2003/2007/2010/2013)

Inside Microsoft Office

by Kara Hiltz

Sometimes you want to have your cake and eat it too! When you chart data in Excel, you don’t need to abandon your raw data. Here’s how to quickly display a data table below your chart.

To display a data table with your chart:

  1. Launch Excel and open any workbook with an existing chart.
  2. Right-click on the chart area and choose Chart Options from the resulting shortcut menu.
  3. Click on the Data Table tab.
  4. Select the Show[…]

Subscribe to Inside Microsoft Office

(get full access to archives and more)