I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second set of data plotted with no data point markers but a line (it could be smoothed or not, depending on the plot) that sits visually above the data points from the first data series. This seems simple, but changing the visual order doesn't work. Any ideas?
(As an example, plot a series like:
0 1 1
1 1.1 1.1
2 1.2 1.2
3 1.3 1.3
4 1.4 1.4
5 1.5 1.5
...with column 1 being the x-axis, column 2 being the data points and column 3 being the data for the line. This then, even after changing the order, gives: