Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart on a user form
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart on a user form
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 -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart on a user form
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add a chart on my user form ? | Charts and Charting in Excel | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Help Fast! Can I add chart to user form in Excel VBA | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
VBA User form | Excel Programming |