I am using Crystal Report .Net for charting my data. I am trying to show line graph with data values for two fields in access database â€œTermâ€?nbsp;and â€œRepaymentâ€? The â€œTermâ€?nbsp;field is DataTime and Repayment is Currency. I want to plot â€œTermâ€?nbsp;field on X axis and â€œCurrencyâ€?nbsp;on Y axis. How can I do that? I am trying to find stuff on the internet but no success until now. Please help. 

Thanks 

when you create your line chart, use the 'term' field in the top data box .. and set the drop down to 'on change of'

to get a realisic time line on the chart, i had to create a seperate table that just holded dates and linked it to my dataset on the date, so that the link would give me blank records for the dates in between the dates i had specified in my table.