choubix
05-23-2008, 01:48 AM
hello,
does anybody here have an example on how to handle histograms in Vba (http://www.excelforum.com/showthread.php?t=645167#)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
does anybody here have an example on how to handle histograms in Vba (http://www.excelforum.com/showthread.php?t=645167#)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