create chart in 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

[Andy Pope]

These lines entered in the immediate window should give you a clue.

Please Login or Register  to view this content.

[choubix]

so the idea is to store the values in an array and to load the values in:

activechart.SeriesCollection(1).values=array(1,2,1)
activechart.SeriesCollection(1).xvalues=array(1,2,3)

do I need to empty the array once it's done??

[Andy Pope]

Once it's done you can do what you like with the array as it will not be linked to the chart.

Note that the series formula will contain those values, and the formula will be limited to 1023 characters. So depending on your data you may not be able to complete this task.

=SERIES(,{1,2,3},{1,2,1},1)

[choubix]

thanks Andy!
I was not aware of the limitations: I will check the data series as you suggested.