Graphing two sets of comparative data over quarters for several places

[Delia Pembrey]

Hello,

I am trying to graph some statistics that look like this:

REGION DERBY LINCOLNSHIRE CLEVELAND NEWCASTLE
LANCASHIRE SHEFFIELD MANCHESTER
HULL CUMBRIA
Registered Users 1531 1102 959 1389 537
297
Visitors 1085 619 774
5098
TOTAL 2616 1102 1578 1389 1311 297
5098
Quarterly Target 400 1000 250 1250
750
Annual Target 1600 4000 1000 5000
3000
Registered Users 564 746 1744 1623
3712 378 0 276 223
Visitors 1087
0 1905
TOTAL 1651 746 1744 1623 3712 378 0
2181 223
Quarterly Target 400 1000 250 1250 0
750 0 0 0
Annual Target 1600 4000 1000 5000 0
3000 0 0 0

Essentially, what I would like to see is:

The male/female ratio per quarter for each area.

So, for instance, you would have 'Derby' on the x-axis,
then graphed, 'Q1' Male/female ratio, and right next to
it, 'Q2' Male/female ratio then a space then the next
area - so that you are able to compare immediately the
trend for each area, but also across all areas... (I hope
I'm making sense).

Any advice would be appreciated - if I need to switch to
Powerpoint, let me know.

Thanks again.

Delia Pembrey
+44 207 765 2012

 

[EZ Money]

I see no reference in your sample data that would indicate gender. How would
one know?