Variable Width 100% Stacked Column Chart

[Earl]

Hi,

I need to make a variable width 100% stacked column chart (similar t
the Column chart with varying width bars from andypope.info but 100
stacked)

The x-axis would contain various market segments and the width would b
proportional to their size, the y-axis divides each segment up by a
attribute.

Any ideas?

Thank

 

[Jon Peltier]

Earl -

Stephen Bullen has a Variable Width Column Chart example on his web site
(http://bmsltd.co.uk), look for FunChrt5.xls on his Excel - Charts
section. Add more nonzero series to stack together.

- Jon

 

[Andy Pope]

Hi Earl,

I have added another technique for creating variable width column
charts. This will also allow for stacked and 100% stacked styles.
(http://www.andypope.info/charts/colwidth2.htm)

Hi,

I need to make a variable width 100% stacked column chart (similar to
the Column chart with varying width bars from andypope.info but 100%
stacked)

The x-axis would contain various market segments and the width would be
proportional to their size, the y-axis divides each segment up by an
attribute.

Any ideas?

Thanks

--

Cheers
Andy

http://www.andypope.info

 

[Tushar Mehta]

Using a time scale is a neat idea! Slick way to create vertical edges
in an area chart.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Hi Earl,

I have added another technique for creating variable width column
charts. This will also allow for stacked and 100% stacked styles.
(http://www.andypope.info/charts/colwidth2.htm)

 

[Earl]

thanks andy