current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Is there a clean way to create and display a static chart or graph on an Excel VBA from from a table of data?

I have seen some solutions creating chart and exporting it as image (example 1, example 2). Is this really the best way?

share|improve this question

put on hold as primarily opinion-based by David Zemens, me how, Jon Egerton, brettdj, zx81 3 hours ago

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.
1  
The first example that you pointed to is the most easy way to show the chart on the userform :) –  Siddharth Rout Aug 20 at 13:42
    
If you have the office web components library available, you can embed a chart object on your userform, but if it's a static chart you may as well just use a picture - you can use Stephen Bullen's PastePicture code if you don't want to actually export an image to disk. –  Rory Aug 20 at 13:55
    
@Rory: Stephen's code also exports the image (to a clipboard though) and is slightly complex. I have used his code HERE –  Siddharth Rout Aug 20 at 14:15
    
@SiddharthRout The code may be complex but it's just plug and play to use it. :) –  Rory Aug 20 at 14:26
    
@Rory: True That :) –  Siddharth Rout Aug 20 at 14:32

Browse other questions tagged or ask your own question.