# 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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### 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>

#### wingingit2018

##### New Member
Thank You,
This should help

Replies
9
Views
1K
Replies
1
Views
476
Replies
23
Views
4K
Replies
0
Views
2K
Replies
0
Views
237

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,861
Messages
5,766,801
Members
425,379
Latest member
thedoctor00

### 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.

### Which adblocker are you using?

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