I'm trying to speed up the performance of a spreadsheet by carrying out the various calculations in VBA using arrays rather than in the spreadsheet cells. From this I want to generate several charts to display the results.
Is there any way I can create the charts using the arrays in VBA rather than having to write the array data into the spreadsheet and then create the charts from there? Basically I want to avoid loads of fields of data and just produce a graph.
I would greatly appreciate any help anyone could offer on this. Many thanks.
Is there any way I can create the charts using the arrays in VBA rather than having to write the array data into the spreadsheet and then create the charts from there? Basically I want to avoid loads of fields of data and just produce a graph.
I would greatly appreciate any help anyone could offer on this. Many thanks.
