Display Multiple Bar Widths

[Mike C]

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]

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