Question

How will you insert chart on a spreadsheet?

CLASS 9
COMPUTER​

Answer 1

Step 1 : (i) Select the data cells for which you want to draw the chart.

(ii) Click on right bottom arrow in Chart group of Insert menu.

(iii) A window will appear showing various chart types and chart subtypes.

(iv) Let us choose column (Clustered column) and press Next.

Step 2: A dialog box will show a preview of the chart with data range. Click on Next.

Step 3: In this step, you can add a title to the chart (Sales in first half of the year). Category (X) axis —> month and value (Y) axis —> sale in thousand rupees. These can be added by choosing the related option from labels group under chart layout menu.

Hope the answer helps

Answer 2

To insert a chart:

Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart. In our example, we'll select cells A1:F6.

From the Insert tab, click the desired Chart command. In our example, we'll select Column.

Choose the desired chart type from the drop-down menu.

The selected chart will be inserted in the worksheet.