Individual column width to represent stacked total
 

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 :-)

Individual column width to represent stacked total
 

I believe this article explains how to do it.

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

HTH,
Barb Reinhardt

"DemonFish" wrote:

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 :-)