PC Review


Reply
Thread Tools Rate Thread

Displaying Chart on Userform (with Scroll Bars)

 
 
wanderlust
Guest
Posts: n/a
 
      7th Nov 2006
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 With Quote
 
 
 
 
Peter T
Guest
Posts: n/a
 
      7th Nov 2006
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
 
Peter T
Guest
Posts: n/a
 
      7th Nov 2006
I meant emf not wmf,

Regards,
Peter T


"Peter T" <peter_t@discussions> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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 With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      8th Nov 2006
To get a vector graphic instead of a bitmap, you need a technique like
Stephen Bullen's here:

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
news:(E-Mail Removed)...
>I meant emf not wmf,
>
> Regards,
> Peter T
>
>
> "Peter T" <peter_t@discussions> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Putting scroll bars on chart sheet Charles Microsoft Excel Charting 5 5th Oct 2005 12:13 PM
adding scroll bars to a chart news2 Microsoft Excel Charting 4 5th Oct 2005 01:27 AM
Activating scroll bars in a text box on a userform Fred Holmes Microsoft Excel Programming 0 18th Nov 2004 10:36 PM
Scroll Bars in TextBox on UserForm Fred Holmes Microsoft Excel Programming 0 29th Oct 2004 12:42 PM
Userform and scroll bars KimberlyC Microsoft Excel Programming 3 2nd Apr 2004 04:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:20 AM.