I'm trying to show the audience overlap/duplication between web si

[Bsacco]

I'm trying to show the audience overlap/duplication between web site A and
web sites b through F.

THe amount is small ranging from .02% to .18% so the scale is difficult.

Any ideas?

 

[JE McGimpsey]

I'm trying to show the audience overlap/duplication between web site A and
web sites b through F.

THe amount is small ranging from .02% to .18% so the scale is difficult.

Any ideas?

Please don't post multiple messages with the same query.

 

[Bsacco]

I'm attempting to show the overlap/duplication between two entities.

In my case, I'm attempting to show the overlap/duplication of two different
audiences (web sites).

Web site A compared to web sites b, c, d, e & f.

So, if web site A has 1000 visitors perhaps 1% of them ALSO visit web site
b, 2% OF THEM ALSO VISIT WEB SITE C, ETC...ETC...

SO, I would like to fid an excel graph that can graphically show this
overlap/duplication.

One of the problems I found was that the scale of the percentages are SO
SMALL that it makes a stacked type of graphic hard to see if you are
comparing them against 100% of web site A's audience...

-bob

 

[Rudolf Hecken]

I believe from what you are saying that this is not an issue for Excel but
for scaling and manipulating your input data statistics.
A) Have you considered a logarithmic representation of your data?
B) How do you derive your data, counting in Excel or how?
Perhaps explaining this might help somebody to come up with a suggestion
where to start.



Bsacco wrote on 3/4/07 7:36 PM

 

[Bsacco]

Sorry for the misunderstanding. All I'm looking for is a simple excel chart
that can graphically display the overlap between two sets of numbers.

What I meant by scaling was that fact that the overlap percentage between
the two set of numbers in very little....so small that it's hard to
graphically show.

Not sure what you mean by logarithmic representation of your data...

I'm just trying to keep this simple in an excel chart.

 

[Mike Middleton]

Bsacco -

Some suggestions:

(A) If there is a similar chart somewhere on the web, give us a URL and we
may be able to tell you how to create it in Excel.

(B) If you don't know what kind of chart you want, take a look at Excel
chart guru Jon Peltier's examples at www.peltiertech.com.

(C) If you don't find an appropriate chart anywhere, post the data that
would be used for the chart. It's usually best to post the actual data
rather than a simplified version of the data.

(D) Since your task does not seem to be Mac-specific, if you don't get
assistance here, consider posting in the microsoft.public.excel.charting
newsgroup. But it's best to post in only one forum at a time.

- Mike
http://www.mikemiddleton.com