Adding Charts

[YCJ]

Hi all,

I have a problem here. I'm trying to add a new chart in my macro, by using "Charts.Add", but seems that it will not pop out a blank chart, but with some names and titles that have been preset, which I don't know how it got there. I've been comparing with other macros that have been done previously, everything looks the same, but those macros with "Charts.Add" will pop out a blank chart, unlike this one that I'm currently working on. Help will be very appreciated because I've been stucked for quite some time.

Thanks in advance,
CJ

 

[amitjzaveri]

Hi,

I believe, if you don't select a data range from current sheet or the data sheet is blank then will come as blank. However that's not worry cause you can update the data range in chart through macro also.

If you can share example code/file then it will be easy to debug.