Hello All,

Is this possible? Create stacked columns for Lease & Depreciation % of
Revenue for years 2006 and 2007 for business units. Note that Lease % &
Depreciation % of revenue is not in contiguous rows.

I would like to have a stacked column to show 2006 lease/depreciation for
each business unit (bu); then another stack column next to the 2006 column to
show 2007 lease/depreciation % for same bu.

Example (for demo purposes I used same figures):
N S E W Total Co
Row 10 = 2006 Lease % Revenue 2.0% 3.0% 5.6% 2.3% 4.3%
Row 12 = 2006 Deprec % Revenue 2.0% 3.0% 5.6% 2.3% 4.3%

Row 16 = 2007 Lease % Revenue 2.0% 3.0% 5.6% 2.3% 4.3%
Row 18 = 2007 Deprec % Revenue 2.0% 3.0% 5.6% 2.3% 4.3%

I have tried several ways and have been unsuccessful. I get all 2006 data
on one side of chart and then on the secondary axis I get all 2007 data.

TIA
Jan