2D vector chart

[Lollek]

Hello,

I met a problem whan I started to use the solution you gave.

In a solution excel sheet there are only 4 vector, but I need more. =>> http://www.excelforum.com/excel-prog...html?p=3332243 2D vectors.xlsx

...I wish to summarize here my goal: I want to visualize the performance of products by labelled scatter chart than to add an arrow for the average of product groups. in the attachment there is draft:2D vectors creator with flexible number of array combined with scatter chart.xlsx

My questions:
Is it possible to have flexible number of vectors? as much as I want (e.g. 8-10?) (How can I add more vector?)
What is the formula of a vector?
Is it possible to combine the vectors with scatter chart with labelled dots? If not what are you recommend to have something like this?

Thanks in advance

Lollek

[Lollek]

Hi

I could solve it. Here you are!2D arrays with scatter chart.xlsx
BR

Lollek