Is there a better and more efficent way to graph multiple rows of data.
My sheet is set so that
B2-B82 are classes
C2-C82 week one scores
D2-D82 week two scores
E2-E82 week three scores
F2-F82 week four scores
Is there a way to create a simple line graph for each class, so that each class has its own graph?
The only way I know how to do it is to go through one at a time to make the graph. I'm hoping there is a time saving method.
Thanks,
My sheet is set so that
B2-B82 are classes
C2-C82 week one scores
D2-D82 week two scores
E2-E82 week three scores
F2-F82 week four scores
Is there a way to create a simple line graph for each class, so that each class has its own graph?
The only way I know how to do it is to go through one at a time to make the graph. I'm hoping there is a time saving method.
Thanks,