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.

There may be depending on the specifics of terms like "pick my data range"
or "make different graphs."

How are your data organized? In the context of a XY Scatter chart, what
does it mean to "sort by subject?"

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <532B5890-3CB0-4E82-8B32-(E-Mail Removed)>,
(E-Mail Removed) says...
> 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.
>

example..suppose i have mary, dick and jane. each has test scores from day
1,2,3,5,6. i want to plot x,y of test score against day. each subject will
have their own graph. i can make a graph for mary but i do not want to
cut/copy mary's graph and reenter dick and janes data in the source data
field. i would like to make many graphs with the x,y data while sorting for
subject (dick, jane..etc.) i have many graphs formany subjects. i want to
"globaly" make graphs based on sorted selection criteria.

"timc" wrote:

> 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.

OK, with that clarification you should be able to adapt the ideas at
Dynamic Charts
http://tushar-mehta.com/excel/newsgr...rts/index.html

particularly example 4.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <03B70068-4065-4389-894D-(E-Mail Removed)>,
(E-Mail Removed) says...
> example..suppose i have mary, dick and jane. each has test scores from day
> 1,2,3,5,6. i want to plot x,y of test score against day. each subject will
> have their own graph. i can make a graph for mary but i do not want to
> cut/copy mary's graph and reenter dick and janes data in the source data
> field. i would like to make many graphs with the x,y data while sorting for
> subject (dick, jane..etc.) i have many graphs formany subjects. i want to
> "globaly" make graphs based on sorted selection criteria.
>
> "timc" wrote:
>
> > 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.
>