On Apr 1, 12:10*pm, "Jon Peltier"
wrote:
I would treat REASON as a non-numeric category then. I would probably then
make a pivot table to help with the analysis, using REASON as a row field,
and Count of Days, Average of Days, StDev of Days and the like as data
fields. I would use several tables and several charts in the investigation
stage; one table or one chart will not be enough to see if there are any
patterns.

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

wrote in message

...
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- Hide quoted text -

- Show quoted text -

Thanks. A Pivot table does seem to be the better fit here. Thanks for
the guidance.