Question

list down the steps to change a column chart into a scatter chart​

Answer 1

Answer:

Right-click on any of the bars.

Click on 'Change Series Chart Type'.

In the Change Chart Type dialog box, make sure Combo category is selected (which it should be by default).

Click on the drop-down for Profit Margin.