Question

Mohit has drawn a column chart for the data shown below. His teacher has now asked him to convert it to a

line chart. Help him to it.​

Answer 1

Select the specified Chart you want to be shown as a line chart, and then click Design > Change Chart Type.

In the Change Chart Type dialog box, select Clustered Column –> Line in the Combo section under All Charts tab,

and then click the OK button.