Thread: How can I combine a stacked column chart and line chart?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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?

Reply With QuoteReply With Quote