Chart on a user form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you add a chart to a userform
What is required

A simple example for a line chart with 1 variable would be greatly appreciated..

Joe
 
There are ActiveX controls out in the market that one can
buy for this, but apart from this or building your own,
Userforms weren't built with this in mind - after all,
you have chart sheets and charhs on spreadsheets, so why
re-invent the wheel?
Having said that, the only way that I know of is to
create a chart on asheet, save it as a gif of bmp file,
then set the saved picture as the image in an image
control.
I beleive Chip Pearson's web site has a demo.

Patrick Molloy
Microsoft Excel MVP
 
Patrick

I agree it sounds like a weird request to want to do this, but the aim was to have a floating graph on a non-modal form that can be positioned and viewed by the user no matter which worksheet they are looking at

Thanks for the info...

joe
 

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

How to create a bubble chart with more than 2 variables 0
Excel Userform Org Chart? 1
Display charts on a userform 4
Excel 2010. How to copy chart format to all charts in sheet 2
paste 2 charts on the same image on a userform 2
Taking a picture of a userform? 2
Image on userform from picture in a worksheet 2
Help: Chart & data 1

Back
Top