Re: Excel VBA - Graph/Chart on Userform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

On Mar 7, 11:05 am, Allan <Al...@xxxxxxxxxxxxxxxxxxxxxxxxx> 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!

.

Relevant Pages

  • Re: Excel VBA - Graph/Chart on Userform
    ... Both approaches put static pictures in the user form, ... Peltier Technical Services, Inc. - http://PeltierTech.com ... need to be able to update the graph/chart every few seconds. ... below, I feel, would be too slow as I would have to update the gif ...
    (microsoft.public.excel.programming)
  • Re: DBD::Chart copying and pasting...
    ... THIAGO LACERDA ZAGO wrote: ... > image comes with its background all in black and the graph ... IIRC, MSFT has had issues with PNG transparent colors, that ... If possible, try exporting as GIF. ...
    (perl.dbi.users)
  • Re: Data for Graphs
    ... Though not as flexible as a user form, ... Tutorials and Custom Solutions ... Peltier Technical Services, Inc. - http://PeltierTech.com ... those years for comparison on a line graph. ...
    (microsoft.public.excel.misc)
  • Re: VFP6 chart using owc10 - need help
    ... Although the example I did, creates a chart as a gif and ... create an html document, adds the gif to it and from there creates and MHTML ... > Having a rough time trying to create a graph from a table using owc10.dll ...
    (microsoft.public.fox.programmer.exchange)
  • GD::Graph with Image Map implementation question
    ... I currently have two embedded perl pages, one that gathers a bunch ... of data and displays it, and another that returns a gif ... I am working on turning the lovely mixed graph image into ...
    (comp.lang.perl.modules)