kind of chart?

[Guest]

I have to make a chart that tracks the following data: employee; office
location (city); age; total months service. I have no idea what type of chart
to use. The actual employee name will not be used in the chart. There are
approximately 15 employees per location so I want to somehow group by
location, but I need to show the individual ages and months of services. Help!

 

[Jon Peltier]

Hi Kim -

This approach might be just what you need. We'll make an XY chart with age
as the X variable and months of service as the Y variable.

First set up the data. Trust me, spending five minutes with data will save
five hours of frustration later. For each office, put data for the employees
into two columns. For example, city 1 should use column A for age and B for
service, city 2 should use column C for age and D for service, etc. Start
the data in row 2, leave cell A1 blank, but the first city name in cell B1,
leave C1 blank, put the second city name in D1, etc.

Now the chart. Select the data in the first two columns, including the blank
in A1 and the city in B1. Start the chart wizard, create an XY (Scatter)
chart. So far so good. Copy the data for the second city, including the
blank in C1 and the city name in D1. Select the chart, go to Edit menu >
Paste Special, and add the data to the chart as a new series, with
categories in the first column and series name in the first row. Repeat this
copy/paste special for each additional office location.

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