Chart on a Userform

With excel 2000 is it possible to add charts like the ones you see in a
worksheet to a userform?
If so how do you link the data to a worksheet that is not currently
selected?
I'm trying to display the set point and position variable for a valve in a
mill.
So each series would only have one value.
Any help would be appreciated.
--
Regards,
Rocky McKinley

Hi Rocky

You can't. Stephen Bullen has a workaround named
PastePicture.zip
at http://www.oaltd.co.uk/Excel/Default.htm ,read its description there.

Or you could use a Excel5 Dialogsheet for this (Rightclick sheettab, Insert
menu), that is what I do when I need dialogs with charts. Just Cut any chart
from a worksheet and Paste it onto the dialog.

HTH. Best wishes Harald


"Rocky McKinley" <[email protected]> skrev i melding
news:[email protected]...
> With excel 2000 is it possible to add charts like the ones you see in a
> worksheet to a userform?
> If so how do you link the data to a worksheet that is not currently
> selected?
> I'm trying to display the set point and position variable for a valve in a
> mill.
> So each series would only have one value.
> Any help would be appreciated.
> --
> Regards,
> Rocky McKinley
>
>
>

Thanks Harald

--
Regards,
Rocky McKinley


"Harald Staff" <[email protected]> wrote in message
news:%[email protected]...
> Hi Rocky
>
> You can't. Stephen Bullen has a workaround named
> PastePicture.zip
> at http://www.oaltd.co.uk/Excel/Default.htm ,read its description there.
>
> Or you could use a Excel5 Dialogsheet for this (Rightclick sheettab,
> Insert
> menu), that is what I do when I need dialogs with charts. Just Cut any
> chart
> from a worksheet and Paste it onto the dialog.
>
> HTH. Best wishes Harald
>
>
> "Rocky McKinley" <[email protected]> skrev i melding
> news:[email protected]...
>> With excel 2000 is it possible to add charts like the ones you see in a
>> worksheet to a userform?
>> If so how do you link the data to a worksheet that is not currently
>> selected?
>> I'm trying to display the set point and position variable for a valve in
>> a
>> mill.
>> So each series would only have one value.
>> Any help would be appreciated.
>> --
>> Regards,
>> Rocky McKinley
>>
>>
>>
>
>