Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column 2 sets of data for 2 years
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column 2 sets of data for 2 years
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column 2 sets of data for 2 years
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked Column 2 sets of data for 2 years
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Excel Stacked Column Graph (3 Divisions for 3 Years) | Charts and Charting in Excel | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
How do I group multiple sets of data for stacked bar chart? | Charts and Charting in Excel | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |