How to create chart by VBA?

[Villalobos]

Hello,

I would like to ask some help regarding that how to create chart by VBA. In my sample there is a chart and I would like if the end user cancel the chart due to any kind of reason after the macro run the chart would be visible again.

Could somebody help me how to do this?

The data in the sample file is just demo.



Thanks in advance the help!

[walruseggman]

So I'm not sure there's anyone that just knows offhand all of the code for all the formatting commands that go into making a chart look just like you want. That may be an incorrect assumption, but...

What I would do is start recording, then create the chart exctly as you want it. The code it creates is going to be pretty close to the exact code you need.

Hope that doesn't sound unhelpful. But it's exactly what I would do when need a chart created VBA.

[Villalobos]

Hi walruseggman,

Thanks, I try to start somehow.