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!!