ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Comparing stacked columns (https://www.excelbanter.com/charts-charting-excel/58903-comparing-stacked-columns.html)

[email protected]

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.



All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com