Scatter Chart

[skissell]

Need help in creating a scatter chart comparing where rates fall compared to other data points.

For example:

Where do the following rates fall:
25.00
26.00
27.00
36.00
22.00

Relative to:
30.00
25.00
22.00

Thanks so much for your help!

[MrShorty]

More detail, or a more specific question?

When I think of a scatter chart, I think of (x,y) pairs of data points. You have only given one set of data. Are these supposed to be the X data, or the Y data? In either case, what are you wanting to use for the other? How much of your question is specific to Excel, and how much of it is a more generic "how do I chart this kind of data" independent of the charting client/application you want to use?

Without more detail, I am inclined to begin with the basic mechanics of creating a scatter chart in Excel. For that, I will refer you to: https://support.office.com/en-us/art...tescatterchart

Does that help, or is there more to your question than just the mechanics of creating a scatter chart?

[skissell]

so maybe I should not use a scatter chart? I have about 60 data points that I would like to see how the compare to benchmark data and I was trying to create a visual. For example: if the benchmark 50th is at 25, then out of the 60 data points how closely are they? Hopefully that is a little more clear. Thanks so much!

[MrShorty]

Something like this maybe?? http://peltiertech.com/excel-charts-...izontal-bands/

Or perhaps something like this: http://peltiertech.com/Excel/Charts/AddLine.html

BTW, is this the same question as here: http://www.excelforum.com/excel-char...hart-help.html

[skissell]

yes it is...thanks so much for your help!