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

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

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

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

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.