You can resize the data grid to agree with the size of the worksheet containing your data.
Resize the grid by typing the correct number of rows and columns of your worksheet in the Grid Sizes section of the data grid editor. You can also indicate the number of levels of labels the rows and columns have.
Example
To resize the data grid for 8 rows and columns of Data:
| 1. | Double-click the field to select the current row value (you can click once, but you will need to delete the existing value). |
| 4. | In the field, type the number 8. |
The data grid should now display 8 columns and 8 rows. The additional column and row cells will be empty.
|
Although the grid redisplays as you exit a cell, those changes have not yet been applied to the chart. You must click or to affect the chart.
|
