5.11 Working with graphs and charts

1.11.5     Adding titles, gridlines and formatting legends

5.11.5.1 Adding Titles  

1.       Click the chart to which you want to add a title.

2.       On the Chart menu, click Chart Options, and then click the Titles tab.

3.       To add a chart title, click in the Chart title box, and then type the text you want.

To add one or more axis titles, click in the appropriate box for each title, and then type the text you want.

5.11.5.2 Adding gridlines

Pie and doughnut charts do not have gridlines.

1.       Click the chart to which you want to add gridlines.

2.       On the Chart menu, click Chart Options, and then click the Gridlines tab.

3.       Select the check boxes for the gridlines you want to display.

Clear the check boxes for the gridlines you want to hide.

1.11.5.3    Formatting Legends  

1.       Click the chart to which you want to add a legend.

2.       On the Chart menu, click Chart Options, and then click the Legend tab.

3.       Select the Show legend check box.

4.       Under Placement, click the option you want.  

5.11.6 Previewing And Printing Chart  

1.       If the chart is embedded on a worksheet, you can adjust where it will print on the page by sizing and moving the chart with the mouse in page break view. To do this, click the worksheet outside of the chart area, and then click Page Break Preview on the View menu.

2.       If you're working with a chart sheet, you can size and scale the chart area, specify how it should be placed on the printed page, and then view it in the preview window. To set printing options for a chart sheet, click the tab for the chart sheet, click Page Set up on the File menu, and then select the options you want on the Chart tab.

To move and size the chart area of a chart sheet by using the mouse, you must click Custom on the Chart tab and then click OK to return to the chart sheet.

Copyright © 2001 Selfonline-Education. All rights reserved.