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" skrev i melding
...
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" wrote in message
...
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" skrev i melding
...
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