Ok,
I'm tasked with creating a chart that represents a Projection in future sales via a Bell Curve. (Honestly, I have no idea why he wants it this way... but Boss says jump, I say how high).
I followed the example given on How to create a bell curve chart template in Excel?
So my Data column goes from 0 - 500,000 (A2:A102), Distribution the same rows, etc. Visually here it is.
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Data[/TD]
[TD]Distribution[/TD]
[TD]Average[/TD]
[TD]standard deviation[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]6.34929E-07
[/TD]
[TD]250000
[/TD]
[TD]146500.8532
[/TD]
[/TR]
[TR]
[TD]5000[/TD]
[TD]6.72614E-07
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10000 (ect)[/TD]
[TD]7.11706E-07
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So this gives me a Lovely Bell curve of information based on $0 - $500,000. Now I have 4 Sales associates that I want to represent onto this chart in separate Marker points on my chart that matches the points on the curve. No problem. Just create a distribution formula based on the Average and Standard Deviation but with each of the sales associates figures. See below
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sales Associate[/TD]
[TD]Projected Sales for Month[/TD]
[TD]Distribution based on above bell chart[/TD]
[/TR]
[TR]
[TD]Greg[/TD]
[TD]232500[/TD]
[TD]2.70378E-06
[/TD]
[/TR]
[TR]
[TD]House[/TD]
[TD]180000[/TD]
[TD]2.42937E-06
[/TD]
[/TR]
[TR]
[TD]Jason[/TD]
[TD]72150[/TD]
[TD]1.30331E-06
[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]33125[/TD]
[TD]9.10322E-07
[/TD]
[/TR]
</tbody>[/TABLE]
When I create a Chart based on all the data A2:A102, B2:B102 (the bell curve), D2,E2(Greg), D3,E3(House), D4,E4(Jason, D5,E5(Chris). My Chart has all Sales Associates shoved up on the far left. Each of their numbers are matching height-wise where it should appear on the Bell curve.
Each of those 4 numbers on the sides are the Distribution number of the corresponding Sales Associate. My question is, how do I get them to appear on the Bell curve as Markers (larger than life points that I can create labels for) and not shoved off to the left side like that.
My second problem is different but related to this chart. Can I create Text Labels that reference the contents of a cell. Meaning, the $ figure for each of my 4 sales associates represented on the chart?
Like shown below.
I know I'm on the right track on how to accomplish this but I'm missing a crucial piece. Any help would be appreciated.
I'm tasked with creating a chart that represents a Projection in future sales via a Bell Curve. (Honestly, I have no idea why he wants it this way... but Boss says jump, I say how high).
I followed the example given on How to create a bell curve chart template in Excel?
So my Data column goes from 0 - 500,000 (A2:A102), Distribution the same rows, etc. Visually here it is.
[TABLE="class: grid, width: 600"]
<tbody>[TR]
[TD]Data[/TD]
[TD]Distribution[/TD]
[TD]Average[/TD]
[TD]standard deviation[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]6.34929E-07
[/TD]
[TD]250000
[/TD]
[TD]146500.8532
[/TD]
[/TR]
[TR]
[TD]5000[/TD]
[TD]6.72614E-07
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10000 (ect)[/TD]
[TD]7.11706E-07
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
So this gives me a Lovely Bell curve of information based on $0 - $500,000. Now I have 4 Sales associates that I want to represent onto this chart in separate Marker points on my chart that matches the points on the curve. No problem. Just create a distribution formula based on the Average and Standard Deviation but with each of the sales associates figures. See below
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Sales Associate[/TD]
[TD]Projected Sales for Month[/TD]
[TD]Distribution based on above bell chart[/TD]
[/TR]
[TR]
[TD]Greg[/TD]
[TD]232500[/TD]
[TD]2.70378E-06
[/TD]
[/TR]
[TR]
[TD]House[/TD]
[TD]180000[/TD]
[TD]2.42937E-06
[/TD]
[/TR]
[TR]
[TD]Jason[/TD]
[TD]72150[/TD]
[TD]1.30331E-06
[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]33125[/TD]
[TD]9.10322E-07
[/TD]
[/TR]
</tbody>[/TABLE]
When I create a Chart based on all the data A2:A102, B2:B102 (the bell curve), D2,E2(Greg), D3,E3(House), D4,E4(Jason, D5,E5(Chris). My Chart has all Sales Associates shoved up on the far left. Each of their numbers are matching height-wise where it should appear on the Bell curve.
Each of those 4 numbers on the sides are the Distribution number of the corresponding Sales Associate. My question is, how do I get them to appear on the Bell curve as Markers (larger than life points that I can create labels for) and not shoved off to the left side like that.
My second problem is different but related to this chart. Can I create Text Labels that reference the contents of a cell. Meaning, the $ figure for each of my 4 sales associates represented on the chart?
Like shown below.
I know I'm on the right track on how to accomplish this but I'm missing a crucial piece. Any help would be appreciated.
