Does anyone know if there's a way to automatically display different bar
widths for different values? For example, I'm working on a market share
analysis. I have three product categories A, B, C. Let's say the size of the
market for product A is $5M, B is $2.5M and C is $2.5M. Then let's say that
the market for product A is owned 50% by Company1 and 50% by Company2. Same
for products B and C.

What I'm hoping to do is for excel to make the bar for Product A twice as
wide as the bar for Products B and C, and shade the bar to show 50% of
Product A going to Company1 and 50% to Company2.

Hope that's not too confusing. If anyone has any suggestions, please let me
know. Thanks!!

Hi,

Have a look at these,

http://pubs.logicalexpressions.com/P...cle.asp?ID=508
http://www.oaltd.co.uk/Excel/SBXLPage.asp#Charting
http://www.andypope.info/charts/colwidth2.htm
http://www.andypope.info/charts/colwidth.htm

Cheers
Andy

Mike C wrote:
Does anyone know if there's a way to automatically display different bar
widths for different values? For example, I'm working on a market share
analysis. I have three product categories A, B, C. Let's say the size of the
market for product A is $5M, B is $2.5M and C is $2.5M. Then let's say that
the market for product A is owned 50% by Company1 and 50% by Company2. Same
for products B and C.

What I'm hoping to do is for excel to make the bar for Product A twice as
wide as the bar for Products B and C, and shade the bar to show 50% of
Product A going to Company1 and 50% to Company2.

Hope that's not too confusing. If anyone has any suggestions, please let me
know. Thanks!!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info