I am new to VBA for Excel, and I need some assistance with the
following. Any help would be greatly appreciated.

On one worksheet in my workbook I have 5 charts. On another worksheet
I have 5 option buttons, and for each button clicked I would like to
display the chart in the upper left (from cell A2) on my worksheet
(just above the option buttons). I am currently able to display the
charts on a userform, but even though I have modified the properties of
the form it has borders ... and I would like for the form to appear to
be resident on my worksheet just above my option buttons. And I would
like the form to appear with out borders. Also, when the graphs are
displayed in the userform they aren't so clear (I tried various
property settings for PictureSizeMode).

I read about transparent forms, and I am not sure if this is exactly
the way I should go with this. Can anyone share some information for
me that might let me know how to accomplish this task.

Thanks in advance,
Julia