Hello,

I have two columns of data that I want to compare. Here is an example of
how they look.
Tone Depth
4 3
5 5
3 2
3 3
3 2
3 2
2 3
2 3
4 4
3 1
3 2
3 1
3 3
3 1
3 3
4 4
3 2
4 3
4 3
4 4
4 3
3 5
3 2


As you can see, there are several points where a Tone of 3 can have a depth
of 5 or 2 or various other numbers between 1 and 5. Tone has the same range
of numbers.

I want to create a chart that compares Tone in terms of Depth, i.e., if it
has a Tone value of 4, it will show the quantitve numbers of correlating
depth values as in (there are 2 entries with a tone of 4 and a depth of 4,
and 1 entry with a Tone of 4 and a depth of 5, and 8 entries with a tone of
4 and a depth of 3, etc.)

I want it to show this for each tone Value, 1-5. I'm not sure how I would
go about creating this chart. Could anyone help me?

As you can see, it's all in two columns, so I would like for excel to pull
out the summary data (i.e. the number of depth entries for each tone type)
by itself so that I don't have to do it manually, if possible. If I were to
do it manually, it might resemble something like this (does not match with
chart above.)

Tone 1
_______
Depth of 1=0
Depth of 2=2
Depth of 3=8
Depth of 4=1
Depth of 5=1

Tone 2
_______
Depth of 1=5
Depth of 2=7
Depth of 3=10
Depth of 4=3
Depth of 5=5

Tone 3
_______
Depth of 1=2
Depth of 2=2
Depth of 3=3
Depth of 4=8
Depth of 5=12

Tone 4
_______
Depth of 1=3
Depth of 2=2
Depth of 3=6
Depth of 4=3
Depth of 5=4

Tone 5
_______
Depth of 1=0
Depth of 2=2
Depth of 3=1
Depth of 4=0
Depth of 5=0

Let me know if you can help! I'm new to charting in Excel.

Thanks!

--Stacey