View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default Comparing stacked columns

I am trying to create the following chart. How do I do it in excel.
Is there and additional template/addin that would help in this?

Data:
Widgets in the market(by geography) My Widgets
50
30
40
20
30
10

Chart:
I am trying to create two stacked bars on the X axis, one for "Widgets
in the market" and "My Widgets". I then want to depict that "My
widgets" is x% of Widgets in the market. I would like to be able to
draw a line from one cell to another (comparing the reduction in share
across geographies).

I wish I could upload a picture somewhere!

Thanks in advance for your help.