Displaying Chart on Userform (with Scroll Bars)
 

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

Displaying Chart on Userform (with Scroll Bars)
 

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

"wanderlust" wrote in message
oups.com...
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

Displaying Chart on Userform (with Scroll Bars)
 

I meant emf not wmf,

Regards,
Peter T


"Peter T" <peter_t@discussions wrote in message
...
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

"wanderlust" wrote in message
oups.com...
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

Displaying Chart on Userform (with Scroll Bars)
 

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

http://oaltd.co.uk/DLCount/DLCount.a...stePicture.zip

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


"Peter T" <peter_t@discussions wrote in message
...
I meant emf not wmf,

Regards,
Peter T


"Peter T" <peter_t@discussions wrote in message
...
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

"wanderlust" wrote in message
oups.com...
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