Hello, I'm a first time poster/website visitor.
In my work I do stochastic simulations which generate hundreds or thousands of pairwise results (each one is a few hundred x,y pairs). I want to plot (overlay) all the results (or at least up to the Excel limit) but of course it's tedious to add each pair to an Excel scatter plot.
By recording a macro I see the VBA code to add the new data pairwise is:
ActiveSheet.ChartObjects("Chart 5").Activate
ActiveChart.SeriesCollection.NewSeries
ActiveChart.FullSeriesCollection(15).XValues = "=profiles!$AC$6:$AC$1000"
ActiveChart.FullSeriesCollection(15).Values = "=profiles!$AD$6:$AD$1000"
where in this example I'm adding a 15th dataset to Chart5 in worksheet "profiles" from the indicated cells.
It seems simple to automate this process to add datasets up to the limit (255?) but I need to use an addressable (row#,col#) description of the data location rather than the "$AC$6" format. My first tries have failed so I ask for help in this forum.
steve
Bookmarks