The x-axis shows dollar values and the y-axis shows each separate month. Each of the three lines has correlating dollar values for every month. 

 

The problem I can't seem to figure out is that it will only allow me to sort by 1 parameter and not two. Basically, the period of performance I need to graph started in Dec 2011 and goes through Nov 2012. I need the month of Dec. to be the first point on the y-axis, not the last.  All the data is plotting correctly, just not in the right order.

 

I've tried adding both month and year in the "on change of" section, but I keep getting an error message saying I either need one "on change of" parameter and many "show values" or many "on change of" parameters and one "show value".

 

Anyone know if there is a work-around for this?

Group 1 is Year, Group 2 is Month

 

Here's how the design view looks (roughly):

 

Group Header 1 - year

Group Header 2 - @month (formatted so the month displays as "01-JAN", "02-FEB", etc.)

Details a - name, month ("mm"), year

Details b - baseline dollars, actual billed, funded dollars

Group Footer 2 - Sum of Baseline Dollars, Sum of Actual Billed, Sum of Funded Dollars

 

The chart is displaying running total fields of: baseline dollars, actual billed, and funded dollars.

 

I tried using your formula using the formula suggestion, but CR didn't like the string type.

much appreciated!!