Multiple series in a chart

[rdemyan via AccessMonster.com]

I am unclear on how one sets up multiple series in a chart. I believe that
one has to select different fields from a table in the SQL statement in order
to do this, but I'm not sure.

However, I would like to select different values from one field in a table in
order to set up different series in a graph.

Here's the specific scenario. I want to be able to graph the usage for
multiple utility types on a single graph. So the table looks as follows with
some sample data

Month_Year Utility_Type Usage
1/1/2006 E 1000
2/1/2006 E 1100
3/1/2006 E 1050
1/1/2006 G 450
2/1/2006 G 475
3/1/2006 G 525

I would like two lines to show up on the graph. One for E (electricity) and
one for G (natural gas). The x-axis would be Month_Year.

How do I do this? I started playing around with a Union Select but couldn't
get it to work.

Any help on this is greatly appreciated.

Thanks.

 

[rdemyan via AccessMonster.com]

Sorry, just to be clear, I want to do this all in code.