E
ENCRYP7OR
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
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 replicatingthe 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