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

's Computer Specifications

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?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:73A53D69-E79D-42B6-BC22-(E-Mail Removed)...
>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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I combine a stacked and clustered column chart in Excel	=?Utf-8?B?VGltIERvbm5lbGx5?=	Microsoft Excel Charting	7	8th Oct 2009 08:17 PM
Re: How to combine stacked column with a cluster column chart?	Jon Peltier	Microsoft Excel Charting	0	19th Dec 2006 01:16 AM
How can I add a line chart in a stacked column chart style?	=?Utf-8?B?R3VpbGhlcm1lIExvcmV0dGk=?=	Microsoft Excel Misc	0	3rd Aug 2006 01:46 AM
Combine stacked column and line chart w/series lines	=?Utf-8?B?YW5jaWxsYXJpZXM=?=	Microsoft Excel Charting	1	7th Apr 2006 11:51 PM
How do I combine a line and a percentage stacked column chart?	=?Utf-8?B?TGl6YQ==?=	Microsoft Excel Charting	1	3rd Feb 2005 01:40 PM