Hi,

The simplest way is to create a column chart based on all your data.
Then select one of the columns that you want to chart as a line. Right
click and choose Chart Type. Select the line chart you need. Repeat as
required for other data series.

Population pyramid, your welcome.

Cheers
Andy

ian_s_mcd wrote:
I am trying to create a business-like chart that has columns and lines
together in one chart. I have five data I wish to show on one chart - some
in column chart format and some in line chart format. Do anyone know what I
mean? And how can I do this? Any kind help would be great.

Many thanks to Andy Pope for his help to my problem (how to create a
population pyramid) last October.

--

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