Hello Everyone,

I've been tasked with updating a 14 year old excel macro running on a
15 year old mac :(.  I'm running into problems with the replicating
the charts.

Heres an example:
http://img99.imageshack.us/my.php?image=0103080255gp2.jpg
(Sorry about the quality, camera phone...)

Each group represents a different area of our state and each group has
its own average line.  I'm having 2 problems.  Grouping the data from
each area together.  When I try to set each area up as a series it
groups the first entry of each area together then the second entry for
each area and so on.

Example:
http://img219.imageshack.us/img219/7544/newpicturexw5.png

Then once I get them grouped I need to make an average line for each
group.  I must have been searching Google for 3 hours and I still
haven't found anything.

Any help would be great!

Thanks
-Mike