Scatter Chart? Bell Curve?

wingingit2018

New Member
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.

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

hotabae

Board Regular
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..."

 Scale Occurances -5 10 -4 12 -3 12 -2 10 -1 20 0 30 1 25 2 8 3 10 4 12 5 8

<tbody>
</tbody>

wingingit2018

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

VBA Geek

MrExcel MVP
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

Board Regular
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.

 Scale Occurances -5 8 7 9 -4 9 11 8 -3 10 13 8 -2 10 8 13 -1 11 13 12 0 15 18 16 1 13 11 12 2 8 10 8 3 13 8 10 4 8 9 11 5 9 7 8

<tbody>
</tbody>

Thank You,
This should help

Replies
0
Views
109
Replies
3
Views
739
Replies
9
Views
3K
Replies
1
Views
719
Replies
23
Views
5K

1,186,112
Messages
5,955,901
Members
438,225
Latest member
rsur

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.

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

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