I've created a xy table chart and I'm now tryign to link the dots but if I
use the linear or the scatered chart type the dots go from the point on the
chart to the x axis instead of linking the points from from the same column
and showing with the same legend.

How can I do that? is that something excell can do?