roll no. name 2/12/2012 14/12/2012 23/12/2012
12 james 56 90 88
23 philip n/a 99 76
45 rosy 55 n/a 85
6 peter 59 74 45
13 sam 69 73 n/a
this data i have in excel sheet,i want to write a vba code that depicts individual student's performance in the tests held on different dates in a chart.the dates where n/a is given should not be plotted on the chart.kindly help.

The chart wizard in Excel should be all you need. just add a chart to your spreadsheet and step through the wizard