Re: Many XY curves with one SeriesCollection

Hi Herbds7,

So many questions and doubts, I will try to answer in order.

I'm not using Excel as a spreadsheet to make tables and calculations, but only as a userinterface for input / output data. Due to his complexity, the processing is outside.

- The data input is processed by an underlying VBA program, that transmits to the worksheet only the outputs to display in tables and charts.

- This program has also a graphic module, a wireframe modeller for surfaces.

- This modeller generates sequences of points (XY coordinates) to draw 2D curves.

- These curves are grouped into "families" or homogeneous groups of curves.

- Each family includes 10-100 curves and goes on the chart with his own format (line color,thickness..etc) to distinguish it from the others.

My worksheet is just one example to explain a simple way, what I'm trying to do.

Those numbers you see in the Range (. Cells (5,2). Cells (42,3)) come from three two-dimensional arrays stored in the memory of the PC.

They represent the grid of three B-splines, but you can considerer them as one of the many families of curves generated by the system.

As regards Excel they are only three curves XY, to draw with the same format.

As I mentioned earlier, I want to feed these data to a uniqueSeriesCollection (not three) via software, without damping data in a range on the worksheet.

The result I want to achieve are three distinct 2D curves.

We have seen how this task can be accomplished by placing these data in a vertical range with empty cells between a set of data and the other.

I am convinced that there must be also a way to realize the same thing via software, giving to the SeriesCollection these arrays, or something else that emulates that range.

The part [.. Particular sequence...] is the one that I don’t know how to write, for this target.

ch.SeriesCollection (SC $). XValues = [.. Particular sequenceof X coordinates of all the curves ..]

ch.SeriesCollection (SC $). = Values [.. Particular sequenceof Y coordinates of all the curves ..]

I hope it's clearer now.

I looked at what you sent me, but it is really another thing. I do not believe may serve me.

However, thanks anyway.

Cheers