OssieMac,

That worked like a charm. Thanks a million!!!!!!!!!! You just saved me
from many hours of tedium.

HobieJuan

"OssieMac" wrote:

Does your data look something like the following table? (I have used a random
string generator for the Emp names.)

Emp Name Emp % Global Ave
Efccxp 80% 82%
Hrlsovd 84% 82%
Yczxyo 85% 82%
Yfzxcv 80% 82%
Hpfxdvu 89% 82%
Hhagans 85% 82%
Ochpees 74% 82%
Tihcctab 77% 82%
Wjkegwku 71% 82%
Djwumo 94% 82%

The formula for the Global average is
=AVERAGE(B:B)

Note that using the column references in the formula in lieu of actual cell
start and finish references allows you to add rows and still copy the same
formula down to the new rows.

If the data looks like the above then you can select the data and create a
column chart. Initially you will see all of the employees charted on a single
chart. (If the chart creates itself on the same worksheet then select the
chart then cut and paste it to a worksheet of its own because it will not
work well with AutoFilter on the same worksheet as the data.)

Apply AutoFilter to the data and select an individual employees name and the
chart will be dynamic and only display that employees percentage and the
global percentage.

If your data does not look like the above and for whatever reason it is not
possible to rearrange it that way then copy a sample of your data and post it
here. (Just use AAA, BBB, CCC etc for employee names to maintain privacy
provisions.)


--
Regards,

OssieMac