VBA XYScatter chart with multiple variable series

[Ralar]

Hi, I am quite new to VBA and I have been watching tutorials and reading forums without any clear answer... here is my problem:

I have a variable number of series (represented in columns side-by-side as) and each one contains a distinct x and y value.

Also, for each serie there's a number variable of data, so in Series1 there're 100 full rows and Series2 88 full rows, and so on in other series.

In order to get a graphical view of the location of each of the values I want to insert them all into a plot. I know it should be a xlXYScatter plot, but for me it would be ideal if all the values represented were equal in shape as is the case with xlBubble (although the z-dimensional value should be equal in all cases).

I have managed to make the XYscatted plot with only one set of values, and I don't know how to add some more...
Can it be programmed in such a way that it goes series by series (variable) and keeping always all the values represented with the same style?

Please Login or Register  to view this content.

Many thanks!

Ramon

[sourabhg98]

When you say equal in shape, you mean in terms of shape or color as well? Also, is the second series in columns D and E?

[Ralar]

Yes, what I really want is something close to this:
Attachment 768761

This chart is generated with a bubble chart by manually adding the data. Selecting as dimensional value z a single value so that all have the same size.
(There're different thickness because values are close one to others)

And my data is like:
Attachment 768762

Yes, the rows are B/C/D/E/F/G...
Cheers

[sourabhg98]

Please Login or Register  to view this content.

[Ralar]

Hello sourabhg98 ! That's exactly what I was trying to do!

Many thanks!

[AliGW]

Administrative Note:

@Ralar

Members will tailor the solutions they offer to the version (NOT release number) of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[Ralar]

Hello! What about If I want to change the initial position to an other cell (as the first data of Series)? ex:L26

Thanks!

Ramon

[sourabhg98]

Change 'stCell' to suit. Also, stCell here must represent the first cell of the header row not the data row.

Please Login or Register  to view this content.

[Ralar]

Wow that's perfect!

Many thanks sourabhg98 !