Dual Chart

[Pete]

Hi

I am wanting to create a chart that has stacked bars as
well as lines going accross it. Excel only seems to give
me one type or another. is there any way I can combine the
2 together.

Cheers

Pete

 

[Bernard V Liengme]

Make the chart with bars. Now right click on one of the data series (one of
the bars) in the chart and from the popup menu select Chart Type and specify
you want Line. Hey presto: a chart with bars and lines!
Best wishes
Bernard