USING CHARTS
Charts are an excellent tool to present data in a worksheet in a visually appealing format which aids in analysing and comparing data. The Chart Wizard button guides through the steps for creating an embedded chart. The steps are as follows:
1. Highlight all the cells that need to be included in the chart including headers.
2. Choose the Chart option from the Insert menu.
3. Choose the suitable Chart type from any of the available types. We will select Column. There are various types available like Pie Chart, Bar Chart, Line Chart, etc.
4. In the Chart Sub-type box, choose the Clustered Column icon to select the chart sub-type.
5. Click Next.
6. The next step displays the address of the cell range selected for preparing the chart. If the need arises, this range can be changed by clicking on the collapse dialog box.
7. Click Next.
8. To place the Subject data on the x-axis, select the Rows radio button.
9. Click Next.
10. Type Class XI Performance in the Chart Title textbox.
11. Type Subjects in the Category (X) Axis field. Subjects will appear as the x-axis title.
12. Type Marks in the Value (Y) Axis field. Marks will appear as the y-axis title.
13. Choose the Data Table tab.
14. Select Show Data Table if required.
15. Click Next.
16. Choose the As Object in Sheet1 option to make the chart an embedded object and part of the current worksheet. In case we need it on a new sheet, then we may choose the option As New Sheet.
17.Click Finish.
