View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How to create chart with columns and 2 lines?

Hi,

Just create a standard line chart and the select the series you want to
plot as columns. Right click and choose Chart Types. Select the required
line chart.

Cheers
Andy

Robert wrote:
Excel will let me create a combination chart with two sets of columns and one
line. I'd like one set of columns and two lines. Can I get it to convert
the second data series from columns to line points?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info