How can I combine a stacked column chart and line chart?
 

I want to combine a standard stacked column chart with a line that, for
example, presents the average value of stacks in each column. This is only
possible by drawing manually a line in the stacked column chart, or is there
a better trick?

How can I combine a stacked column chart and line chart?
 

Hi,

Create your stacked column chart using all the data.
Select the series that contains the average data. Change the series chart
type to Line.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Huib" wrote in message
...
I want to combine a standard stacked column chart with a line that, for
example, presents the average value of stacks in each column. This is only
possible by drawing manually a line in the stacked column chart, or is
there
a better trick?