View original (French)

Right median insertion on graph

blux Posted messages 2045 Registration date   Status Moderator Last intervention   -  
blux Posted messages 2045 Registration date   Status Moderator Last intervention   -
Hello,

I have a graph (scatter plot) with points based on the x and y of my two data series (age and height).

I want to add two lines (one vertical and one horizontal) that represent the median of each series, to 'divide' my graph into four zones.

I've tried a lot of things that didn't work (pseudo median columns to reintegrate into the graph...), and I'm getting lost (and Excel is too: I've managed to crash it several times).

So thanks to any kind soul who feels competent to help me...

--
A+ blux 
 "Fools dare to do anything.
It's even how we recognize them."

3 answers

Answer 1 / 3
ccm81 Posted messages 11033 Status Member 2 434
 
Hello

Can you send the relevant part of your file in Excel 2003 format to cjoint.com and attach the obtained link to your next message with some details about what you want to get

Have a good continuation
0
blux Posted messages 2045 Registration date   Status Moderator Last intervention   3 455
 
Actually, I would like to have the same type of chart as the one here (sheet 'graph1')

My knowledge of Excel VBA is basic and I don't understand how the chart is created. I've looked through the object explorer, the code, but I see nothing (and yet I regularly program in Access VBA..., but here: nothing, nada, niente, nicht, nothing...)
0
Answer 2 / 3
Frenchie83 Posted messages 2254 Status Member 339
 
Hello
example
horizontal bar
x1 x1' y1 y1'
-200.00 200.00 200.00 200.00

vertical bar
x2 x2' y2 y2'
100.00 100.00 200.00 -200.00

to be adjusted to the dimensions of your graph
best regards
0
blux Posted messages 2045 Registration date   Status Moderator Last intervention   3 455
 
Uh yes, but I want it to represent the median, so it is subject to change depending on the values of the series (otherwise, I take a screenshot and edit it in Paint...)
0
Answer 3 / 3
ccm81 Posted messages 11033 Status Member 2 434
 
I do not see what macros would do here
1. You calculate median_LD and median_DP (as in your sheet, with the ranges being defined dynamically - OFFSET....)
2. You add a new series to your chart: the point with coordinates (median_LD, median_DP)
3. In the format of this point, you add error bars X and Y with a percentage of 100%
0
blux Posted messages 2045 Registration date   Status Moderator Last intervention   3 455
 
Thank you, I will test it as soon as possible...
0
blux Posted messages 2045 Registration date   Status Moderator Last intervention   3 455
 
If I add a series with n times the median values or with a unique pair, I can't add a vertical error bar (Excel 2007)!
I looked online, I don't see where I can tell it that I want a different error bar but vertical.

Edit:

Found it, I need to plot the series with 'secondary axes'...
0