Question

Mohit has drawn a column chart for certain data. But, later on he decided that a line chart would be better than a column chart.

  i)  What should he do to change the chart type?                                                                                          1

 ii)   How can he move the chart to a new worksheet?​

Answer 1

Answer:

Explanation:

To change the chart type in Excel

• Select a chart or one of the chart's elements.
• Then click the “Design” tab of the “Chart Tools” contextual tab in the Ribbon.
• Then click the “Change Chart Type” button in the “Type” button group.

Move a chart to another worksheet

• Click anywhere in the chart.
• Under Chart Tools, on the Design tab, in the Location group, click Move Chart.
• Do one of the following: To move the chart to a new worksheet, click New sheet, and then in the New sheet box, type a name for the worksheet.