Apple Numbers Chart - I CANNOT get the data in the chart the way I want it no matter which way I do it. AAARRRGGGG!!!!

Click on the chart

Edit Data References

In the bottom left corner of the window it will say "plot columns as series". Change that to "plot rows as series".

Closest I can get to your exact question is shown below.

The names are on the left exactly as shown in the table. This is chart legend.

The dates are across the top. This is a second chart placed above the main one with everything turned off but the X axis category labels. The X axis labels on the main chart are turned off. You

Each data point on a chart has a Y value (your rankings) and an X value (your dates). The vertical axis (the left side of a chart) has numbers to indicate the Y values of your data points. The horizontal axis has the X values. Each person is a different line/color on the chart. The legend tells you which color line/point is which person. There are no charts where the X axis is on the top.

If you want the names to appear on the chart, with a 2D scatter chart you can do something like shown below. It will be a hot mess, though, if two or more people have the same or similar rankings on the same dates. Names will overlap. It would be the same hot mess if there was a way to move the names to the left of the chart (which there is not).