all,



If anyone has experience with graphs, I would really appreciate some help. I have this graph:



What I want are data plot points for those months that don't have one. Here is my query that it pulls from:

Code:
Period	TotalProfit
Apr 2007	$323.00
Dec 2007	$578.40
Jan 2007	$390.51
Jul 2007	$318.51
Mar 2007	$2,040.00
Nov 2007	$106.17
Sep 2007	$4,844.10
Aug 2008	$144.00
Jul 2008	$2,012.00
Jun 2008	$776.95
Mar 2008	$507.50
May 2008	$3,130.00
Sep 2008	$106.17
Apr 2009	$1,200.96
Feb 2009	$521.71
Jan 2009	$867.60
Mar 2009	$1,005.00
As you can see, there are missing periods where there were no entries. I have already written a UDF that creates a new table with all the missing records and a '0' as the profit amount. Charting from that table will give me what I want, but the code is long and I hope not necessary. I have searched the dialogs in chart view and can't seem to find anything that fills in these periods with 0's. Does anyone know if Access can do this? thank you!