Hello All and Happy Friday!

I am creating a semi-complex chart and having trouble with the secondary x-axis.

Current data uses distance and the x-axis and data is plotted as lines and bars indicating depth (y axis).

I now have added a secondary x-axis and want to plot a scatter chart over the existing chart to show width of points at a particular distance (imagine vertical bars and horizontal lines across distance and now want vertical line/scatter on top on new axis).

When I first created the chart, it drew the data the wrong way round and I clicked switch row/column and it fixed the problem. I now want to do this with the data on the new axis but it will not let me edit the data without changing all the data in the spreadsheet...

Does anyone have any ideas?

Many thanks,

Damien