I have attached an excel sheet
Consider Students are having exam daily and data is received daily in the format below for different subject
Sheet-1
Math
01-05-20 02-05-2020 03-05-20 04-05-20
Student A
Student B
Student C
Student D
Sheet-2
English
01-05-20 02-05-2020 03-05-20 04-05-20
Student A
Student B
Student C
Student D
Objective :
i was trying to plot a graph similar to indicated in image
for single student and its all subject variation on graph
1. Student A-
x Axis -Days
y Axis -Marks of Student-A
1. can we do it without copy pasting the data of single student in one sheet.
2. Can we make an dropdown on graph itself for different students
Excel sheet is attached fro reference
Thanks in advance
Bookmarks