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.
myliene
0
Newbie Poster
ChrisPadgham
113
Posting Whiz
The chart wizard in Excel should be all you need. just add a chart to your spreadsheet and step through the wizard
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.