PDA

View Full Version : creating a chart using VBA



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

f2e4
05-23-2008, 02:25 AM
can you post some of your code for loop

choubix
05-23-2008, 02:46 AM
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
05-23-2008, 06:32 AM
Cross posted
http://www.excelforum.com/showthread.php?t=645167