Good morning ladies and gentlemen,

I would like to start off by saying that I have been searching high and low
for a solution to the following problem. Some of the solutions Ive found on
this site and others are either to difficult or not exactly what Im looking
for.

I would like to see an example of the following€¦.

I would like to be able to place a graph/chart on a user form so that data
can be displayed in real time. This would be like having a strip chart
showing data from a data logger. Data is stored within the spreadsheet and a
new row of data is added every n number of seconds/minutes (user defined scan
rate). I have the incoming data setup and working flawlessly, I would just
like to be able to reference a few cells and graph them on a user form every
time new data is brought into the spreadsheet.

Any help I can get would be greatly appreciated.

Thanks!

I read yesterday about being able to do this:

When new data is brought into sheet:
a) create graph
b) copy as a .gif
c) paste that .gif to the userform

Go he http://j-walk.com/ss/excel/tips/tip66.htm


Chris

On Mar 7, 11:05 am, Allan wrote:
Good morning ladies and gentlemen,

I would like to start off by saying that I have been searching high and low
for a solution to the following problem. Some of the solutions I've found on
this site and others are either to difficult or not exactly what I'm looking
for.

I would like to see an example of the following....

I would like to be able to place a graph/chart on a user form so that data
can be displayed in real time. This would be like having a strip chart
showing data from a data logger. Data is stored within the spreadsheet and a
new row of data is added every n number of seconds/minutes (user defined scan
rate). I have the incoming data setup and working flawlessly, I would just
like to be able to reference a few cells and graph them on a user form every
time new data is brought into the spreadsheet.

Any help I can get would be greatly appreciated.

Thanks!

Thanks cht13er!

I saw that one as well. I think that would work great for one time use. I
need to be able to update the graph/chart every few seconds. The method
below, I feel, would be too slow as I would have to update the gif thousands
of time during a test run.

"cht13er" wrote:

I read yesterday about being able to do this:

When new data is brought into sheet:
a) create graph
b) copy as a .gif
c) paste that .gif to the userform

Go he http://j-walk.com/ss/excel/tips/tip66.htm


Chris

On Mar 7, 11:05 am, Allan wrote:
Good morning ladies and gentlemen,

I would like to start off by saying that I have been searching high and low
for a solution to the following problem. Some of the solutions I've found on
this site and others are either to difficult or not exactly what I'm looking
for.

I would like to see an example of the following....

I would like to be able to place a graph/chart on a user form so that data
can be displayed in real time. This would be like having a strip chart
showing data from a data logger. Data is stored within the spreadsheet and a
new row of data is added every n number of seconds/minutes (user defined scan
rate). I have the incoming data setup and working flawlessly, I would just
like to be able to reference a few cells and graph them on a user form every
time new data is brought into the spreadsheet.

Any help I can get would be greatly appreciated.

Thanks!

Try Stephen Bullen's PastePicture, a little over half way down -

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

Regards,
Peter T

"Allan" wrote in message
...
Thanks cht13er!

I saw that one as well. I think that would work great for one time use. I
need to be able to update the graph/chart every few seconds. The method
below, I feel, would be too slow as I would have to update the gif
thousands
of time during a test run.

"cht13er" wrote:

I read yesterday about being able to do this:

When new data is brought into sheet:
a) create graph
b) copy as a .gif
c) paste that .gif to the userform

Go he http://j-walk.com/ss/excel/tips/tip66.htm


Chris

On Mar 7, 11:05 am, Allan wrote:
Good morning ladies and gentlemen,

I would like to start off by saying that I have been searching high
and low
for a solution to the following problem. Some of the solutions I've
found on
this site and others are either to difficult or not exactly what I'm
looking
for.

I would like to see an example of the following....

I would like to be able to place a graph/chart on a user form so that
data
can be displayed in real time. This would be like having a strip chart
showing data from a data logger. Data is stored within the spreadsheet
and a
new row of data is added every n number of seconds/minutes (user
defined scan
rate). I have the incoming data setup and working flawlessly, I would
just
like to be able to reference a few cells and graph them on a user form
every
time new data is brought into the spreadsheet.

Any help I can get would be greatly appreciated.

Thanks!

Both approaches (John's and Stephen's) put static pictures in the user form,
but you can rerun frequently, each time the data updates, and I don't think
you'll see any lag.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Peter T" <peter_t@discussions wrote in message
...
Try Stephen Bullen's PastePicture, a little over half way down -

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

Regards,
Peter T

"Allan" wrote in message
...
Thanks cht13er!

I saw that one as well. I think that would work great for one time use. I
need to be able to update the graph/chart every few seconds. The method
below, I feel, would be too slow as I would have to update the gif
thousands
of time during a test run.

"cht13er" wrote:

I read yesterday about being able to do this:

When new data is brought into sheet:
a) create graph
b) copy as a .gif
c) paste that .gif to the userform

Go he http://j-walk.com/ss/excel/tips/tip66.htm


Chris

On Mar 7, 11:05 am, Allan wrote:
Good morning ladies and gentlemen,

I would like to start off by saying that I have been searching high
and low
for a solution to the following problem. Some of the solutions I've
found on
this site and others are either to difficult or not exactly what I'm
looking
for.

I would like to see an example of the following....

I would like to be able to place a graph/chart on a user form so that
data
can be displayed in real time. This would be like having a strip
chart
showing data from a data logger. Data is stored within the
spreadsheet
and a
new row of data is added every n number of seconds/minutes (user
defined scan
rate). I have the incoming data setup and working flawlessly, I would
just
like to be able to reference a few cells and graph them on a user
form
every
time new data is brought into the spreadsheet.

Any help I can get would be greatly appreciated.

Thanks!