It is necessary to build a diagram in Excel based on the coordinates of 2 vertex groups. Here is how the constructed graph should look like and the corresponding coordinates of the vertices: alt text

The problem is that I do not know how to specify the coordinates of the vertices for the data ranges. The coordinates themselves (illustrated), for example, are:

XY ----------- 5 16 5 13 5 10 5 7,5 5 3,5

and

 XY ----------- 12,5 15 12,5 8

    2 answers 2

    By specifying the X coordinates of the column names and putting down the Y coordinates of the corresponding vectors as values, something like this will work. Of course, not as beautiful as on the screen @ srgg67, but Excel graphics are simply not capable of this.

    Example of the resulting graph

      A simple schedule does not achieve this. Combine a few?

      A good resource for building graphs.