Jon,

I haven't worked much with charts. But, if I understand you correctly, I
get the impression the data on worksheet needs to be rearranged(at least same
years in consecutive rows)...correct? Not possible per "boss". I guess I
would have to copy info to another worksheet to accomplish. Am I on the
right track?


"Jon Peltier" wrote:

Jan -

You can do this successfully with a different data layout. The links on this
page will show you how:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jan" wrote in message
...
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