I am charting market share of 9 companies across 13 individual
countries. I have the 13 countries on the x-axis, and %age market
share on the y-axis. Columns are all stacked to 100%.
What I would like to do is have the width of each individual column
vary according to the total units for that country (kinda similar to
how a bubble chart would do this if that makes sense)
Does anyone know a way to achieve this?

Excel 2003 btw :-)