Stacked Column 2 sets of data for 2 years

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,

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?
 
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
 
Back
Top