From the chart options dialog box displayed, you can select Titles, Axes, Gridlines, Legend, Data Labels and Data Table tabs and make the necessary changes.
To add title to a chart
· In the Chart title: text box, enter the name for the chart, i.e. Exam results.
· In the Category (X) axis: text box, enter a title for the X axis, i.e. Subject.
· In the Category (Y) axis: text box, enter a title for the Y axis, i.e. Mark score.
· In the example used, the screen will be as illustrated.
To customize the chart axis
· From the Chart Option dialog box displayed, click on the Axes tab.
· It allows you to control the way the axes are displayed, you can tick or un-tick the check box to see the effects on the chart.
To customize chart gridlines
· From the Chart Option dialog box displayed, click on the Gridlines tab.
· You can choose to display the major and minor X and Y gridlines for the axis by clicking on the particular check box.
To customize chart legend
· From the Chart Option dialog box displayed, click on the Legend tab.
· You can choose to display or not the chart legend and the placement of the legend in the chart by clicking on the radio button.
To customize data labels
· From the Chart Option dialog box displayed, click on the Data Labels tab.
· You can choose to display or not the chart data labels by clicking on the radio button.
To display a data table
· From the Chart Option dialog box displayed, click on the Data Table tab.
· You can choose to display or not the chart data table by ticking on the check box.
· Click on the Next button to continue and this will display the final page of the Chart Wizard – Chart Location.
0 comments:
Post a Comment