On Apr 1, 10:44*am, "Jon Peltier"
wrote:
REASON sounds like a non-numeric data range. An XY chart cannot accept
non-numeric data. Would a bar chart be better?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

wrote in message

...



Hello,

I need to create a scatter plot in Excel 2007 and I am clueless.

I have two columns, one called REASON, the other called LENGTH OF
TENURE IN DAYS.

I have selected both columns and attempted to insert a Scatter chart,
but to no avail. Can you please help?

Jeff- Hide quoted text -

- Show quoted text -

The reasons are coded numerically. An example of my columns appears
below. There are over 600 separate entries in my spreadsheet. The
reason codes come from my Human Resources department. I am not certain
that I even need them. What I am trying to see is if the reasons
people quit and their tenure are related somehow.

Reason Code Length of Tenure in Days
1253 65
1259 67
2351 79
1542 125
2351 47
1253 98
1253 364
1542 168