Creating Graph with Additional Column

[sunsetbay]

Hey all,

I currently have four columns of data. I am trying to plot a line graph with Month on X-Axis and a new variable known as Frequency on Y-Axis ( whereby the value of Frequency = Count / Exposed )

Month AgeGroup Count Exposed
January 21 - 30 1 0.9
January 31 - 40 0 0.145
February 21 - 30 2 0.785
February 31 - 40 0 0.441
February 41 - 50 1 0.9633
March 31 - 40 0 1.632
March 41 - 50 0 0
April 21 - 30 3 0.752
April 31 - 40 1 0
April 41 - 50 1 0.689
May 21 - 30 1 0
June 31 - 40 0 2.6987
June 41 - 50 0 0

Notice that the months repeat itself due to different AgeBand which makes it tricky because say for E.g: The Frequency for January will be adding up the total number of count and divide it by the total sum of exposed. It's not as simple as Frequency = Count / Exposed;

Does anyone have an useful graph script to help me out? Or would you guys suggest using Enterprise Guide 4 to work this out? If so, does anyone know how to go about it?

Hope this is not too complicated!

Cheers
Yennie

~~I live to die and Die to Live~~