Changing data types on Line/bar with two axes
 

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?

Changing data types on Line/bar with two axes
 

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

rojo6964 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info