Stacked bar chart/normal bar chart with text values

[Lystellion]

My company gets leads from its website.

We give leads different Lead sources depending on where someone came from. Some come from adverts (PPC), others from search engines (Organic search) and so on.

We give leads different Lead values, depending on what someone was interested in. So for example, all leads with value '3' are reasonable leads for a course we run.

I want to answer two questions relevant to our marketing:

1) For each Lead value, what proportion came from what Lead source? So for example, what proportion of reasonable leads (value '3') came from PPC? what proportion came from organic search? And so on.

I think the best way to do this is to show a stacked bar chart, but my attempts to do it don't consolidate all PPC (for example) as a single figure. I just end up with lots of bars, each one showing the same height with 3 being the value of the Y axis (see my data below).

How should I create a stacked bar graph which will show the correct proportions? Here's a basic picture of what I'm looking for:

2) For each Lead value, how many inquiries did we get from each Lead source? So for example, how many reasonable leads (value '3') came from PPC? How many came from organic search? And so on.

I think the best way to do this is to show each Lead value on the X axis, and then show the number on the Y axis. Again, I have had trouble doing this. Here's a basic picture of what I'm looking for:

Here's a sample of my data:

[B]Excel 2007[/B][TABLE]
<tbody>[TR="bgcolor: #E0E0F0"]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Lead source[/TD]
[TD]Lead value[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]PPC[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Online other[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Organic search[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Organic search[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Organic search[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Organic search[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Organic search[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]PPC[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Online other[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]PPC[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD]PPC[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD]Organic search[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD]Online other[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD]Online other[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD]Organic search[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD]Organic search[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD]PPC[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD]Online other[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD]Organic search[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD]Organic search[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD]Organic search[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD]Online other[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD]Organic search[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD]Online other[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD]Organic search[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD]Organic search[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD]PPC[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD]Organic search[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD]Organic search[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD]Organic search[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD]Organic search[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD]Organic search[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD]Organic search[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD]PPC[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD]PPC[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD]Organic search[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD]Organic search[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD]Online other[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD]Organic search[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD]Organic search[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: center"]42[/TD]
[TD]PPC[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: center"]43[/TD]
[TD]Organic search[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD]Organic search[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: center"]45[/TD]
[TD]PPC[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: center"]46[/TD]
[TD]PPC[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: center"]47[/TD]
[TD]PPC[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]48[/TD]
[TD]Organic search[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]49[/TD]
[TD]Organic search[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD]Online other[/TD]
[TD="align: right"]8[/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]June 20 - Sept 20 2013[/B][/COLOR][/CENTER]

[TABLE="width: 85%"]
<tbody>[TR]
[TD][B]Worksheet Formulas[/B][TABLE="width: 100%"]
<tbody>[TR="bgcolor: #E0E0F0"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A1[/TH]
[TD="align: left"]Lead source[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B1[/TH]
[TD="align: left"]Lead value[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A2[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B2[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A3[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B3[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A4[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B4[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A5[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B5[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A6[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B6[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A7[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B7[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A8[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B8[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A9[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B9[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A10[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B10[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A11[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B11[/TH]
[TD="align: left"]1[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A12[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B12[/TH]
[TD="align: left"]2[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A13[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B13[/TH]
[TD="align: left"]2[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A14[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B14[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A15[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B15[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A16[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B16[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A17[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B17[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A18[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B18[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A19[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B19[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A20[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B20[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A21[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B21[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A22[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B22[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A23[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B23[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A24[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B24[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A25[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B25[/TH]
[TD="align: left"]3[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A26[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B26[/TH]
[TD="align: left"]4[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A27[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B27[/TH]
[TD="align: left"]4[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A28[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B28[/TH]
[TD="align: left"]5[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A29[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B29[/TH]
[TD="align: left"]5[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A30[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B30[/TH]
[TD="align: left"]5[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A31[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B31[/TH]
[TD="align: left"]5[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A32[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B32[/TH]
[TD="align: left"]5[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A33[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B33[/TH]
[TD="align: left"]5[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A34[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B34[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A35[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B35[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A36[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B36[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A37[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B37[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A38[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B38[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A39[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B39[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A40[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B40[/TH]
[TD="align: left"]6[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A41[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B41[/TH]
[TD="align: left"]7[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A42[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B42[/TH]
[TD="align: left"]7[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A43[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B43[/TH]
[TD="align: left"]7[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A44[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B44[/TH]
[TD="align: left"]7[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A45[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B45[/TH]
[TD="align: left"]7[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A46[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B46[/TH]
[TD="align: left"]7[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A47[/TH]
[TD="align: left"]PPC[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B47[/TH]
[TD="align: left"]8[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A48[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B48[/TH]
[TD="align: left"]8[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A49[/TH]
[TD="align: left"]Organic search[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B49[/TH]
[TD="align: left"]8[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]A50[/TH]
[TD="align: left"]Online other[/TD]
[/TR]
[TR]
[TH="bgcolor: #E0E0F0"]B50[/TH]
[TD="align: left"]8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Many, many thanks to anyone taking time to respond to me. I was Googling this until about 10:15am this morning, but I can't seem to have the same success I normally do. I think I don't know quite enough to put in the right terms.

 

[Lystellion]

Still struggling with this one.