When I try to graph data from two different sheets, the program is producing
erroneous results. I'm trying to use a bar graph to show progress (or
decline) in scores from one physical fitness test to the next. The graph is
showing no data for person 11, even though they DO have data in at least one
of the sheets.
The error might be due to the fact that while the people are the same on
both sheets (same number and order), some on the first sheet don't have
results while they do on the second (and vice versa) and some didn't take
part in either test. Could this have an effect or is there something else
I'm doing wrong? I'm defining both columns using the "Series" function.