View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default 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