COLUMN AND LINE CHARTS IN ONE CHART

[Guest]

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]

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.

Re: Population pyramid, your welcome.

Cheers
Andy