I am creating a bar graph that, for example, list a class full of students
and their grades on an assignment. I want to be able to graph all of the
results, have the graph all in the same color, and then enter in a cell the
student ID I am reviewing, then have the graph update to change the color of
that student's grade on the chart. As this is going to be a lookup tool, I
need this to be like a macro that changes the graph automatically versus
clicking on it and doing it manually. Anyone able to help?