Because charts are built from the active grid, changing the grid changes the chart. Even while the chart is displayed, you can change the underlying grid by dragging columns in or out, by pivoting, by drilling down, by changing the measure, or by changing the measure function. Pivoting the grid will not rotate the chart, it will rotate the grid, resulting in a different set of data to be graphed. For the purposes of charts, the grid is broken into label cells, and data cells. Label cells are yellow and blue, and for most chart types, become the labels and legend strings for the chart.
Data cells are white.
Only the values in data cells are used for graphing. You can rotate the 3D charts along the three axes by clicking the mouse in various parts of the view. Chart Properties You can modify and accent the appearance of your charts in the Chart Properties dialog box. To access the Chart Properties dialog box, click the Properties button at the top of the display. Tab Description Pie Used to enter information about how the pie chart will display.