Stacked Column 2 sets of data for 2 years

[Guest]

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

 

[Jon Peltier]

Jan -

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

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

- Jon

 

[Guest]

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]

Leave the original data where it is for your boss, then in another range set
up links so you get the arrangement of data as described in the pages I
cited. Use copy and paste special-link so changes in the main table are
reflected in the chart.

- Jon