Manage gridlines for groupaxis through formula or c# code.

Hello Friends,

I want to add gridlines for group axis of my line chart dynamically. I am using 'Date' (contains time in 12 hours format) field for group axis and value 'Sale' field as data axis and I also have low and high series for sale.

I want to show gridlines after sales for each date (there can be multiple sale value for each date).

Here are the sample values:

Date Sale 11 July 2012 10:00 AM 100 11 July 2012 12:00 PM 200 11 July 2012 01:30 PM 400 11 July 2012 10:00 PM 300 12 July 2012 02:00 PM 100 13 July 2012 04:00 PM 200 14 July 2012 11:30 AM 400 14 July 2012 12:00 PM 500 14 July 2012 09:00 PM 400 15 July 2012 09:00 AM 200 16 July 2012 10:00 AM 100 16 July 2012 11:00 AM 100 16 July 2012 12:00 AM 500

Please tell me is there is any way to add dynamic gridlines, through formula or .NET SDK.

Thanks in advance.