Complex Scatterchart with multiple variables

**marca** · 06-30-2017, 05:55 AM

Screenshot (17).png

Hello.

I am looking to create a scatter chart - as displayed with multiple variables: the x variables are time 0,1,...; the corresponding y variables are reference 0,1,... in the same column.
When I click and (ctrl) click multiple selection for x and y - I get the chart at the bottom (which I dont want) - instead I want the chart in the upper right corner, which I manually configured by select data - adding x and y variables , manually. Which is quite a lot for my data points, so I am looking for to do this in an automatic process ?!

Many thanks for your help ! Marc

**MrShorty** · 06-30-2017, 11:15 AM

If I understand what you are doing, that is probably the easiest way to do it with that data layout.

If you are familiar with VBA (Office's macro programming language), then you can write and debug a procedure that will mimic that manual process. It will involve some kind of loop (http://www.excel-easy.com/vba/loop.html ) that adds each data series to the chart (https://msdn.microsoft.com/VBA/Excel...n-object-excel ).

The manual approach you are using is almost certainly the easiest, but it is tedious. Which of the other two approaches to use depends on which one you feel most comfortable working with. Personally, I would tend towards the "change the layout in the spreadsheet" approach, but there is not good reason for that preference.

A better arrangement of the data would be something like:

Please Login or Register  to view this content.

Probably the hardest part of this starting from the layout you have is compiling the list of all the x values from rows 2 to 15. Once you have that, you can pull down the Y values using a lookup function.