Individual column width to represent stacked total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DemonFish - 13 Jul 2007 08:57 GMT

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

Reply to this Message

Barb Reinhardt - 13 Jul 2007 11:30 GMT

I believe this article explains how to do it.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=508

HTH,
Barb Reinhardt

> I am charting market share of 9 companies across 13 individual
> countries. I have the 13 countries on the x-axis, and %age market
[quoted text clipped - 5 lines]
>
> Excel 2003 btw :-)

Reply to this Message