Column chart - adjustable width of every column?

[sdkdgg]

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.

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]S1[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.4[/TD]
[TD]0.1[/TD]
[/TR]
[TR]
[TD]S2[/TD]
[TD].2[/TD]
[TD].1[/TD]
[TD].15[/TD]
[TD].6[/TD]
[/TR]
[TR]
[TD]S3[/TD]
[TD].3[/TD]
[TD].5[/TD]
[TD].25[/TD]
[TD].1[/TD]
[/TR]
[TR]
[TD]S4[/TD]
[TD].4[/TD]
[TD].2[/TD]
[TD].2[/TD]
[TD].2[/TD]
[/TR]
</tbody>[/TABLE]

 

[VoG]

AJP Excel Information - Variable width columns may help you.

 

[Priit]

Thanks VoG,

I had the same problem and found a way to do it with the error bars but it was quite clumsy compared to the solution on the link you gave.

And sdkdgg, have you had any success with your code? Can you share it?

Best wishes,
Priit