Chart embedded in UserForm

T

Tim

Hi,

I'm looking at various different ways of embedding charts
in UserForms. I've seen an example on j-walk.com on how
to programmatically export a chart as a .gif file and
then embed it in a userform, but since the data I'm
plotting is feeding in real-time and changes rather
quickly, it causes a lot of flickering since the whole
image changes as opposed to just the relevant data series.

Can anyone point me to a good tutorial on some other
solutions, e.g. like how to use the mschart controls or
other similar objects?

Many thanks and kind regards
Tim
 
A

Andy Pope

Hi Tim,

Check out Stephen Bullen's PastePicture.zip example,
(http://www.bmsltd.co.uk/Excel/Default.htm)
Hi,

I'm looking at various different ways of embedding charts
in UserForms. I've seen an example on j-walk.com on how
to programmatically export a chart as a .gif file and
then embed it in a userform, but since the data I'm
plotting is feeding in real-time and changes rather
quickly, it causes a lot of flickering since the whole
image changes as opposed to just the relevant data series.

Can anyone point me to a good tutorial on some other
solutions, e.g. like how to use the mschart controls or
other similar objects?

Many thanks and kind regards
Tim
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Picture Size in UserForm/Picture Control. 8
How do I place a chart on an Excel VBA Userform & drive w/spinners 1
Embedded chart alignment 3
Protecting Embedded Chart 1
Chart SeriesCollection Names 2
Dynamic radar chart 0
Charts with Time as X-Axis 6
Excel 2007 Chart Update While Macro Is Running 4

Top