How do I do a combination STACKED column and line chart on 2 axis

's Computer Specifications

I want to have a combination chart on 2 axis. I want the columns to be
stacked. I want the line to be on a second Y axis....please help!

's Computer Specifications

Hi,

Create the chart using all the data as a stacked column chart.
Double click the series that you want as a line on the secondary axis.
On the Axes tab select Secondary axis. The right click the series and
pick Chart type to change it the required line chart type.

Cheers
Andy

rwtuning wrote:
> I want to have a combination chart on 2 axis. I want the columns to be
> stacked. I want the line to be on a second Y axis....please help!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create a stacked column/line chart combination?	=?Utf-8?B?Q29yaQ==?=	Microsoft Excel Charting	3	2nd Aug 2006 03:23 AM
Combination stacked column/line chart	=?Utf-8?B?Q29yaQ==?=	Microsoft Excel Charting	0	31st Jul 2006 06:50 PM
line-column combination chart, with stacked columns	=?Utf-8?B?YW5uZXdjcHNz?=	Microsoft Excel Charting	1	5th Jun 2006 08:51 PM
Re: line - stacked column chart on 2 axis	Jon Peltier	Microsoft Excel Charting	0	8th Sep 2004 04:11 AM
Re: line - stacked column chart on 2 axis	Debra Dalgleish	Microsoft Excel Charting	0	8th Sep 2004 01:54 AM