Excel 2007 Scatter Plot Issue

[jeffch1970]

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

 

[Jon Peltier]

REASON sounds like a non-numeric data range. An XY chart cannot accept
non-numeric data. Would a bar chart be better?

- Jon

 

[jeffch1970]

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
_______










- 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

 

[Jon Peltier]

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
_______

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
_______










- 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

 

[jeffch1970]

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
_______







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.