reference line on x-axis based on value on y-axis

[Anonymous]

Hi,

I have a reference line on the y-axis where the accumulated value reaches 80 percent. What i want to do now is have a reference value on the x-axis that crosses the reference value on the y-axis. Is it possible?

//A.

[pat_agen]

hi,

yes it is. On the Reference Lines dialogue box (reached from chart properties->Presentation) you have the radio buttons for Location. here you can stipulate x-axis or y-axis or both.

This combined with the correct expression for your trend line will get you what you want.

[Anonymous]

I've come that far to but i don't know how to write the expression för the x-axes reference line.

The expression i have for the accumulated line in my chart is =sum(Sales). and then boxes for "Relative" and "Full accumulation" is checked. How do i express that in the reference line expression sayin that the line should be where the 80% of that accumulated value is?

//A.

[#4]

Hi,

  can you explain some more clearly.

-Jai

[pat_agen]

hi,

what is on your x-axis? what kind of chart are you displaying?

On a second check the options I gave you are valid when you are plotting a scatterplot with expressions on both x and y-axis. If you are using a bar chart or line chart only the y-axis reference line options are available.

If you have your expression = sum(sales) as above with "relative" and "full accumulation" ticked then a reference line with the following expression should work:

sum(total Sales) * 0.8.

This still only gives you a refrence line on the y-axis but maybe this is all you require.

[Anonymous]

I have a combo chart where customer's the dimension but i have them in classes of 55 customers in each class (total values on the x-axes: 100). Then i have to expressions.

First expression is sum(sales) and the values are represented in bars and sorted by the expression in decending order.

The secound expression is also sum(sales) but with the boxes "Relative" and "Full accumulation" checked. This is a line in the chart. Lokking like the red line in this picture: http://en.wikipedia.org/wiki/File:Root_graphs.svg

I have one reference line parallell with the x-axis where the line meets 80%. Now i want to have a line parallell with the y-axis and this line should be where the 80% reference line and the secound expression line crosses.

//A.

[pat_agen]

hi,

I don't have the answer to your question but am interested to see if anyone out there can figure it out.

What I have seen is that a combo chart , like the line and bar charts does not give you the option of putting a reference line on the x-axis. A scatter plot plots a dimension against 2 variables both of which could have reference lines, whereas you wil have adimesnion, albeit a synthetic one going across the x-axis. You woud have to figure out a way of finding in which class the 80th fractile of total sales falls and the perhaps colour that bar accordingly.

I looked at you link to te cahrt in wikipedia and was wondering if you managed to start off your line in the bottom let corner and if so, how did you do it?

anyway good luck and let us know how you get on.