Stacked bar with two axis

[TIFFSTER2001]

I have a stacked bar chart with 8 areas that I need to show breakdown, annual planned, and planned data on. One of the areas is much larger than the other areas so I want to put it on a seperate axis. I tried to go through format but it's not giving me the option.
layout:

area Breakdown annual planned planned
1
2
3
4
5
6
7
8

 

[GlennUK]

Have those items as separate series, by adding columns to your data and arranging the values accordingly:

Excel Workbook
	A	B	C	D	E	F	G
1	Name	Breakdown	Annual Planned	Planned	BreakdownArea 1	Annual PlannedArea 1	PlannedArea 1
2	Area1	0	0	0	243	546	345
3	Area2	23	43	32	0	0	0
4	Area3	22	42	32	0	0	0
5	Area4	18	45	23	0	0	0
6	Area5	24	43	37	0	0	0
7	Area6	23	44	33	0	0	0
8	Area7	21	45	34	0	0	0
9	Area8	22	43	32	0	0	0
Sheet1

Then select the last 3 series to be on the secondary axis.