Changing data types on Line/bar with two axes

[rojo6964]

I have four data series, it shows 2 as bars and 2 as lines. I want to show
just one series as bars and 3 as lines. How do I change data series 2 from
bars to lines?

 

[Andy Pope]

Hi,

Right click the series and pick Chart Type. Select the required chart type.

It is normally quicker to start with a line chart for all 4 series and
then select one of the series to change to a bar/column chart.

Cheers
Andy