Alternative to Stacked Bar/Column

[Guest]

I am looking for a clearer way to represent data than a stacked bar/column chart would.

I am showing cross-shopping for four different grocery stores. This is how the data is layed out:

Store A B C D
A 100% 57% 37% 45%
B 50% 100% 45% 55%
C 30% 65% 100% 66%
D 35% 17% 56% 100%

The data are read in columns. For example, 50% of Store A shoppers also shop at Store B. The percentages are not exclusive and do not sum to 100%.

I think a Venn diagram would be the best way to represent the data: Does Excel have such an option?

If not, any ideas that would represent this chart effecrtively, other than a stacked bar/column?

Thanks for you help!

A-Rock

 

[Jon Peltier]

A-Rock -

I'd try to use a clustered column, not a stacked column, since your
percentages don't add up to anything meaningful. Your categories would
be A, B, C, and D, and over each category would be four columns, for A,
B, C, and D. I think however you'd have Excel plot it, the reader would
need a while to make sense of it.

Excel doesn't provide Venn diagrams (well, I hear one of the more recent
versions has it, but I understand that it just draws the circles). A
Venn diagram could also show interactions, like how many of shoppers at
A and B shop at C but avoid D.... The Venn would work with the actual
counts, though, and not with percentages.

- Jon

 

[Andy Pope]

You may find this article on Venn diagrams of interest.
(http://www.andypope.info/ngs/ng9.htm)

I am looking for a clearer way to represent data than a stacked bar/column chart would.

I am showing cross-shopping for four different grocery stores. This is how the data is layed out:

Store A B C D
A 100% 57% 37% 45%
B 50% 100% 45% 55%
C 30% 65% 100% 66%
D 35% 17% 56% 100%

The data are read in columns. For example, 50% of Store A shoppers also shop at Store B. The percentages are not exclusive and do not sum to 100%.

I think a Venn diagram would be the best way to represent the data: Does Excel have such an option?

If not, any ideas that would represent this chart effecrtively, other than a stacked bar/column?

Thanks for you help!

A-Rock

--

Cheers
Andy

http://www.andypope.info