Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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:

I would like the line over the data!

share|improve this question
    
Is the chart you show the result you want to achieve? –  pnuts Nov 28 '12 at 12:55
    
No, I want the line to be on top, such that the data points would be mostly hidden. On my normal dataset there would be hundreds of underlying points, and I want to clearly be able to see the trended data. –  Alistair Collins Nov 28 '12 at 14:11

1 Answer 1

up vote 1 down vote accepted

To get the red line to overlay the blue data points I selected Scatter with only Markers first and then Change Series Chart Type for the red data series to Scatter with Straight Lines. Not sure whether this is the sort of result you want:

SU511786 example

so I have not bothered to work out whether the result you show might be as above but in a different order!

share|improve this answer
1  
Thank you, that does exactly what I require! –  Alistair Collins Nov 29 '12 at 8:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.