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

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

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jan" wrote in message
...

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