Scatter Chart? Bell Curve?

[wingingit2018]

I have likert scale data:
-29.0 through +29.5

I have four different likert scales that need to be graphed in some manner.
the original thought was to create a bell curves to demonstrate the commonality of each set of data.
- - That has proven difficult, or impossible as I cant figure it out.

Then the thought moved to using frequency to give a comparative view.

I have watched all the videos.
the challenge currently is the inability to create intervals using negative numbers.
I am using excel 2013..

I have only taken an excel class in college 20 yrs ago. I'm confident there must be a way to get all four of these sets of data onto one chart (that is not a bar graph - per boss' orders)

I would love to hear any thoughts.
Thank you for your time

 

[hotabae]

If you set up your "scale" and frequency like this, you can use the chart wizard and make a "Scatter Plot with Smooth Lines and Markers" (after selecting the data)

Then, you could add the other data sets via right-clicking the graph and using "data sets..."

[TABLE="width: 116"]
<tbody>[TR]
[TD]Scale[/TD]
[TD]Occurances[/TD]
[/TR]
[TR]
[TD]-5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]-4[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]-3[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]-2[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]-1[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[wingingit2018]

Is it possible to have multiple lines of frequency on one chart?

 

[VBA Geek]

Is it possible to have multiple lines of frequency on one chart?

Hello - could you post your data so it would be easier to understand?

 

[hotabae]

If you set your data up like this (left column is scale, right3 are frequency/occurances), and highlight the data (no headers - seen here as A2:D12), the "Scatter Plot with Smooth Lines and Markers" in the chart wizard will do what I think you are asking.

[TABLE="width: 256"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Scale[/TD]
[TD="width: 192, bgcolor: transparent, colspan: 3"]Occurances[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-5[/TD]
[TD="bgcolor: transparent"]8[/TD]
[TD="bgcolor: transparent"]7[/TD]
[TD="bgcolor: transparent"]9[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-4[/TD]
[TD="bgcolor: transparent"]9[/TD]
[TD="bgcolor: transparent"]11[/TD]
[TD="bgcolor: transparent"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-3[/TD]
[TD="bgcolor: transparent"]10[/TD]
[TD="bgcolor: transparent"]13[/TD]
[TD="bgcolor: transparent"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-2[/TD]
[TD="bgcolor: transparent"]10[/TD]
[TD="bgcolor: transparent"]8[/TD]
[TD="bgcolor: transparent"]13[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]-1[/TD]
[TD="bgcolor: transparent"]11[/TD]
[TD="bgcolor: transparent"]13[/TD]
[TD="bgcolor: transparent"]12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]15[/TD]
[TD="bgcolor: transparent"]18[/TD]
[TD="bgcolor: transparent"]16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]13[/TD]
[TD="bgcolor: transparent"]11[/TD]
[TD="bgcolor: transparent"]12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]2[/TD]
[TD="bgcolor: transparent"]8[/TD]
[TD="bgcolor: transparent"]10[/TD]
[TD="bgcolor: transparent"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]3[/TD]
[TD="bgcolor: transparent"]13[/TD]
[TD="bgcolor: transparent"]8[/TD]
[TD="bgcolor: transparent"]10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]4[/TD]
[TD="bgcolor: transparent"]8[/TD]
[TD="bgcolor: transparent"]9[/TD]
[TD="bgcolor: transparent"]11[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]5[/TD]
[TD="bgcolor: transparent"]9[/TD]
[TD="bgcolor: transparent"]7[/TD]
[TD="bgcolor: transparent"]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[wingingit2018]

Thank You,
This should help