| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting scroll bars on chart sheet | Charts and Charting in Excel | |||
| adding scroll bars to a chart | Charts and Charting in Excel | |||
| Activating scroll bars in a text box on a userform | Excel Programming | |||
| Scroll Bars in TextBox on UserForm | Excel Programming | |||
| Userform and scroll bars | Excel Programming | |||
Linear Mode
