Scatter Chart? Bell Curve?

wingingit2018

New Member
Joined
Feb 15, 2018
Messages
5
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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

hotabae

Board Regular
Joined
Apr 18, 2018
Messages
167
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..."

ScaleOccurances
-510
-412
-312
-210
-120
030
125
28
310
412
58

<tbody>
</tbody>
 

hotabae

Board Regular
Joined
Apr 18, 2018
Messages
167
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.

ScaleOccurances
-5879
-49118
-310138
-210813
-1111312
0151816
1131112
28108
313810
48911
5978

<tbody>
</tbody>
 

Forum statistics

Threads
1,147,498
Messages
5,741,505
Members
423,663
Latest member
kaveh87rsh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top