Excel VBA - Graph/Chart on Userform

[Allan]

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!

 

[cht13er]

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 here: http://j-walk.com/ss/excel/tips/tip66.htm


Chris

 

[Allan]

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.

 

[Peter T]

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

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

Regards,
Peter T

 

[Jon Peltier]

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