Chart Data Grid

Each chart created with the Chart Wizard in the spreadsheet, plot sheet or 3D plot is associated with a data grid. This data grid is a table that holds the data being charted. The data grid can also include labels used to identify series and categories on the chart. The following illustration shows the relationship between a data grid and a chart.

In most cases, each column in the data grid translates to one series on the chart. However, a number of chart types require two or more columns of data to chart a series. These chart types include XY Charts, Polar, Bubble, Hi-Lo and Gantt charts.

You can easily modify the data in the Chart Data Grid and change the size of the Chart Data Grid by using the Edit Chart Data window.