**apologies in advance if this topic has already been brought up, but i
couldn't find it.

i want to be able to set up a form to dynamically graph diffferent size sets
of equipment data for a continuously growing data set. where i run into the
biggest problem is i can't figure out how to define the size of the data set.
for example, if one data set has 60 points and another 75, i either cut off
the additional 15 points on the set of 75, or i get 15 extra junk points on
the set of 60. how do i tell the graph that i want the number of points to
change?

i want to do this in a form that will access a database. that way, i can
select whatever type of equipment i want, and from there select the type of
reading, be it amps, pressure, bearing vibration, or something else.

See Tushar Mehta's site for a short course on Dynamic Charting and some sample
files.

http://www.tushar-mehta.com/excel/ne...rts/index.html

Alternative site is Stephen Bullen's.

http://www.oaltd.co.uk/Excel/Default.htm

Download either or both of FunChrt1 and FunChrt7


Gord Dibben MS Excel MVP

On Thu, 14 Jun 2007 13:39:02 -0700, bradyarz
wrote:

**apologies in advance if this topic has already been brought up, but i
couldn't find it.

i want to be able to set up a form to dynamically graph diffferent size sets
of equipment data for a continuously growing data set. where i run into the
biggest problem is i can't figure out how to define the size of the data set.
for example, if one data set has 60 points and another 75, i either cut off
the additional 15 points on the set of 75, or i get 15 extra junk points on
the set of 60. how do i tell the graph that i want the number of points to
change?

i want to do this in a form that will access a database. that way, i can
select whatever type of equipment i want, and from there select the type of
reading, be it amps, pressure, bearing vibration, or something else.

thanks, that was exactly what i was looking for.

"Gord Dibben" wrote:

See Tushar Mehta's site for a short course on Dynamic Charting and some sample
files.

http://www.tushar-mehta.com/excel/ne...rts/index.html

Alternative site is Stephen Bullen's.

http://www.oaltd.co.uk/Excel/Default.htm

Download either or both of FunChrt1 and FunChrt7


Gord Dibben MS Excel MVP

On Thu, 14 Jun 2007 13:39:02 -0700, bradyarz
wrote:

**apologies in advance if this topic has already been brought up, but i
couldn't find it.

i want to be able to set up a form to dynamically graph diffferent size sets
of equipment data for a continuously growing data set. where i run into the
biggest problem is i can't figure out how to define the size of the data set.
for example, if one data set has 60 points and another 75, i either cut off
the additional 15 points on the set of 75, or i get 15 extra junk points on
the set of 60. how do i tell the graph that i want the number of points to
change?

i want to do this in a form that will access a database. that way, i can
select whatever type of equipment i want, and from there select the type of
reading, be it amps, pressure, bearing vibration, or something else.