Displaying Chart on Userform (with Scroll Bars)

[wanderlust]

Hi,
I have a userform which displays a chart. I used a workaround (on
John Walkenbach's Site) whereby, I save the Graph as a Gif image and
paste it onto the userform.
I have an image placeholder on the userform that accesses the GIF
file. The problem that I have is that when I display the Chart, I would
like to have scrollbars so that the user can move around when the chart
is larger than the image placeholder on the userform.
I tried to zoom the chart to fit in the image placeholder, but it
seems to distort the chart and I can't read the numbers very clear. Is
there any way I can add Scrollbars to the image placeholder on the
userform or is there any other method to do this.
Thanks,
Ravi

 

[Peter T]

Put the image control on a frame. Set frame's Scrollbars to both and set
scroll height & width to suit. These can be changed at run time to adjust to
a newly loaded picture size if say you set the image control's autosize to
true.

Concerning image quality, particularly when scaled, try a wmf instead of
gif.

Regards,
Peter T

 

[Peter T]

I meant emf not wmf,

Regards,
Peter T

Put the image control on a frame. Set frame's Scrollbars to both and set
scroll height & width to suit. These can be changed at run time to adjust to
a newly loaded picture size if say you set the image control's autosize to
true.

Concerning image quality, particularly when scaled, try a wmf instead of
gif.

Regards,
Peter T

 

[Jon Peltier]

To get a vector graphic instead of a bitmap, you need a technique like
Stephen Bullen's here:

http://oaltd.co.uk/DLCount/DLCount.asp?file=PastePicture.zip

- Jon