Adjusting graphs
You can transpose data, switch the x and y axes in scatter graphs, and adjust the cell column width and decimal precision. To adjust data, use the graph data dialog box.
To transpose rows and columns of data: - Choose Object > Graph > Data.
- Click the Transpose button
. Labels and data that were listed across the top row are now listed along the left column. When the categories and legends are reversed, all the data is transposed accordingly.
To switch the x and y axes in a scatter graph: - Choose Object > Graph > Data.
- Click the Switch X/Y button
to reverse the data columns.
To adjust a column width manually: - In the graph data dialog box, position the pointer at the edge of the column you want to adjust. The pointer changes to a double arrow.
- Drag the handle to the desired position.
To reset the column width, you must drag the column width again; you cannot use the Cell Style dialog box. If you drag the column width to zero, the column reverts to the column width set in the Cell Style dialog box.
To change the width of columns you have not previously changed manually: - Click the Cell Style button
in the graph data dialog box. - Enter a value between 0 and 20 in the Column Width text box. Click OK.
Changing the value in the Column Width text box changes the width of the columns in the graph data dialog box only; it has no effect on the width of columns in the graph.
To adjust decimal precision: - Click the Cell Style button in the graph data dialog box.
- Enter a value between 0 and 10 in the Number of Decimals text box. The default is 2. This means that if you enter the number 4, it appears in the graph data dialog box as 4.00; if you enter the number 1.55823 with the Number of Decimals text box set to 2, the cell displays 1.56. Click OK.
|