Excel 2000 xy scatter chart - plotting median data line

[cjashwell]

Hi
Apologies for cross-posting, but can anyone help me to plot a median line across a scatter chart I'm working on in Excel 2000? I don't want a trendline, just a line representing the median values across my hundreds of data points.
Much gratitude in advance for any help offered.
CJA.

 

[Dreamboat]

CJA: Just add another series with the same data in all cells, or use the drawing tools (view-toolbars-drawing) and draw a line on top of your chart.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com

 

[Hasit]

Not sure I understand you question about the median line. Do you want a line going through the middle of your plots, or do you want to identify the median value of a series of data points, from which you want to draw a median line.

If you want a line going through your plots, Dreamboat's suggestion of drawing in a line would work. If you want to plot something, then I do not understand.

I am assuming that you are talking about the mathematical definition of median (i.e. the middle number of a series, so the median for 1, 2, 3, 4, 5 is 3).

 

[cjashwell]

Hi
Thanks Dreamboat and Hasit for your contributions. I was perhaps a little unclear, due to confusion in my own mind! I did initially mean median in the mathematical sense, but then I realised that this would require two lines, one for each of the data series. What I am in fact after is a line that plots the mode of all the data points (i.e. the most 'popular' data position). This is so I can see the correlation between my two data series. Any suggestions on this gratefully received.
CJA

 

[Hasit]

Aha. Well, what you will need to do is to set up 2 more columns, one for each of the existing data series. Then, type in the following formula (assuming that your first data series sits in column A1 through A30):

=MODE(A1:A30)

This should give you the most popular number, which you can then plot on the same graph as an additional data series.

 

[cjashwell]

Yeah, that's done it! Thank you very much, Hasit!

CJA.

 

[Dreamboat]

I want your knowledge, hasit. Do you hear me? I WANT IT NOW!!!

PS: CJA: You need to give hasit a star. Just look at the bottom left of his post that gave you the answer and click on the "click here to mark this post as a helpful or expert post". That way others recognize the post as being particularly helpful, and hasit can continue to move up the list of experts at your right.

http://www.VictimPhotos.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word
techsupportgirl@home.com