Hello to all,
Here is a problem relating charts in Excel.
In above figure, I would like to solve two problems.
1. Firstly, I want to quickly make the graph of all roll nos. separately(like the one i have shown for roll no.101).
Some kind of formula or programming etc. so that automatically separate charts for each roll no. containing same variables (like Test 1 marks %age, Test 2marks %age, etc.) are drawn quickly.
2. Secondly, when charts are being made in this way automatically (which of course i know the geeks here are capable here to do it), then i want that only that chart become visible to me for which i clicked on the cell of that specific Roll No..
Example when i click on the cell of roll no. 105 ( i.e.. A6) the the chart corresponding to Roll No.105 pops out or is displayed next on right side (as shown for roll no. 101 in grey colour) .
When i click on Roll No.106 (i.e.. A7) then only chart of 106 is displayed, the previous one of roll no. 105 should someway hide or be invisible.
Though i know hyperlink is one of the option for second problem, but it would be very comfortable if the chart is someway not displayed in some another window (like in another excel sheet or picture manager etc.) but it should pop out right next to the roll no. clicked in same excel sheet.
Do Note one thing that i have hide some column cells which actually contained actual marks of Tests Or Assignments. The column cells that are visible to you have percentages formulas applied to them.
Thanx for reading patiently, I hope I have made myself clear of the problem i m facing.
Waiting eagerly for the solution from the geniuses........