Alternative to Stacked Bar/Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
You may find this article on Venn diagrams of interest.
(http://www.andypope.info/ngs/ng9.htm)

A-Rock said:
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top