i have an excel file called report card,where there is student data containing their marks in tests held on different dates. i want to write a vba program that depicts individual student's performance in a chart,the dates where the
student's did not appear for the test is marked as n/a ,it should not be shown in the chart,kindly help.thank you.