Hi guys,
I made a normal 100% stacked column based on the following data. Simply select all the cells in the following table, and click 100% stacked column in Excel 2010. Because the A/B/C/D columns they have different weight when it comes to importance. Therefore, I am thinking to make the four stacked columns to have different "column width". Let's say, A-1, B-1.5, C-4, D-3, so A column has the default width as assigned by Excel, B will have 1.5 times of the A's width, and so on for C and D column.
Has any one figured out how to change/customize width of a single column of a stacked column chart?
I am also planning to use VBA to make many 100% stacked column charts in a batch mode. So if anyone can give tips how to customize width of different columns by VBA, that would be great. Cheers.
Appreciate any tips! Thank you a lot.
<tbody>
</tbody>
I made a normal 100% stacked column based on the following data. Simply select all the cells in the following table, and click 100% stacked column in Excel 2010. Because the A/B/C/D columns they have different weight when it comes to importance. Therefore, I am thinking to make the four stacked columns to have different "column width". Let's say, A-1, B-1.5, C-4, D-3, so A column has the default width as assigned by Excel, B will have 1.5 times of the A's width, and so on for C and D column.
Has any one figured out how to change/customize width of a single column of a stacked column chart?
I am also planning to use VBA to make many 100% stacked column charts in a batch mode. So if anyone can give tips how to customize width of different columns by VBA, that would be great. Cheers.
Appreciate any tips! Thank you a lot.
A | B | C | D | |
S1 | 0.1 | 0.2 | 0.4 | 0.1 |
S2 | .2 | .1 | .15 | .6 |
S3 | .3 | .5 | .25 | .1 |
S4 | .4 | .2 | .2 | .2 |
<tbody>
</tbody>