i have a large amount of data that is an xy scatter. it is xy data that
pertains to many subjects. i need to make a graph for each subject. as of
now i make the first one and then cut and paste to a new one, use source data
and change the x and y data. this does take me a long time since i have alot
of subjects. is there another way to pick my data range and sort by subject
to make differenct graphs without cutting/pasting and constantly changes the
source data. i tried tinkering with a pivot table but everytime i changed the
table, all tables changed.