ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Creating Stacked Columns Chart (https://www.excelbanter.com/charts-charting-excel/177487-creating-stacked-columns-chart.html)

robin

Creating Stacked Columns Chart
 
MS Excel 2003 wizard allows you to create a standard chart called "stacked
columns". Even using custom charts, I can not get it to create one
stacked-column per category. In this case the three categories are companies
(eg, co1, co2, co3), but I need two stacked-colmuns per category. One stacked
column would show principal & loan amt and second stacked-column would show
average and adjustments. In the end, each company should have two
stacked-columns on the chart. I hope I haven't lost you. It's hard to
explain.

Andy Pope

Creating Stacked Columns Chart
 
Hi,

Have a look here for more information
http://peltiertech.com/Excel/ChartsH...sterStack.html

Cheers
Andy

Robin wrote:
MS Excel 2003 wizard allows you to create a standard chart called "stacked
columns". Even using custom charts, I can not get it to create one
stacked-column per category. In this case the three categories are companies
(eg, co1, co2, co3), but I need two stacked-colmuns per category. One stacked
column would show principal & loan amt and second stacked-column would show
average and adjustments. In the end, each company should have two
stacked-columns on the chart. I hope I haven't lost you. It's hard to
explain.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com