Chart on a Userform

  • Thread starter Thread starter Rocky McKinley
  • Start date Start date
R

Rocky McKinley

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.
 
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
 
Thanks Harald

--
Regards,
Rocky McKinley


Harald Staff said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display charts on a userform 4
Image on userform from picture in a worksheet 2
show a userform and still work on the below worskheet? 3
Excel Userform Org Chart? 1
paste 2 charts on the same image on a userform 2
Sheet change event not fired when showing a userform modal 2
Display variable in userform 5
How do I place a chart on an Excel VBA Userform & drive w/spinners 1

Back
Top