creating a chart using VBA

[choubix]

hello,

does anybody here have an example on how to handle histograms in Vba please?

I have a loop where the "i" are the X axis values
the formula inside the loop returns the Y axis values

how do I pass the (XY) series to an histogram in vba without having to write the X and Y into cells then select the range and create the histogram??

thanks!
Alex

[f2e4]

can you post some of your code for loop

[choubix]

hi f2e4,


will have to post tomorrow as the code is at the office now...
I've been told to use arrays to pass the series to a chart in vba. but apparently there are some limitations.

[Andy Pope]

Cross posted
http://www.excelforum.com/showthread.php?t=645167