To change the chart type without losing custom formatting you have applied, use the Chart Type button on the Chart toolbar. ...