Different widths for each column in a 100% stacked column chart
 

I would like to present a chart that has 3 columns of data with each column
being the same height and each column being split into different components
(i.e. a 'typical' 100% stacked column chart). Each column represents a
different market (split between the players in that particular market) and
the markets are of diferent size. What I would like to do is make the width
of each column vary depending on the size of the market. Effectively the
height of the columns is the same and the vertical splits reflect the
relative size of the components within each column but in addition I would
like the width of the columns to reflect the relative size of each market. I
have seen this in a Powerpoint presentation before but assume it was lifted
from Excel. I have Office 2007.

Different widths for each column in a 100% stacked column chart
 

Hi,

Jon has information on their creation.
http://peltiertech.com/WordPress/marimekko-charts/

Or mine,
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Chart Explorer" <Chart wrote in message
...
I would like to present a chart that has 3 columns of data with each column
being the same height and each column being split into different
components
(i.e. a 'typical' 100% stacked column chart). Each column represents a
different market (split between the players in that particular market) and
the markets are of diferent size. What I would like to do is make the
width
of each column vary depending on the size of the market. Effectively the
height of the columns is the same and the vertical splits reflect the
relative size of the components within each column but in addition I would
like the width of the columns to reflect the relative size of each market.
I
have seen this in a Powerpoint presentation before but assume it was
lifted
from Excel. I have Office 2007.