Excel Chart Help

[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

 

[Ed Ferrero]

Hi Mike,

Take a look at this sample
http://www.edferrero.com/content/10 Columns and Lines.xls
It might be what you are looking for.

Sorry, but it is not shown on the main part of my website - google will not
pick it up.

Ed Ferrero
www.edferrero.com

 

[ENCRYP7OR]

Hi Mike,

Take a look at this samplehttp://www.edferrero.com/content/10%20Columns%20and%20Lines.xls
It might be what you are looking for.

Sorry, but it is not shown on the main part of my website - google will not
pick it up.

Ed Ferrerowww.edferrero.com

Perfect! It makes much more sense now...
Thanks a million Ed!