need min and max value in a line chart with extra condition.please help

[#1]

Hi all,

Please help me out to resolve the below issue.

If you open my application attached,I have a line chart and 2 text boxes.My line chart Xaxis is ranging from 75 to 95 presently because I have given the static min and max expressions in the properties to change it dynamically.(=round(avg(strike_price1)-10,1) )

The same way I want to do for my Y axis.

ie: for Xaxis value 75 I want min and max value of the expression present

payoff values=value*sum(Nominal_Quantity)

min and max of value*sum(Nominal_Quantity) at 75

min and max of value*sum(Nominal_Quantity) at 95

This is to make the chart more readable and not messy.

Please can you help me out please???????? is this possible???

[#2]

Can anyone help me out please???????????

[#3]

sorry your requirement of max value is not very clear.

[#4]

hi sorry I guess my question sounded  complicated.Will try to make it simple.

In my application I have made my X axis values dynamic,by setting up the static min and max expressions.

which are

:round(avg(strike_price1)-10,1)

round(avg(strike_price1)+10,1) I think this is clear.

Now I want to make my Y axis also dynamic corresponding with the X axis.how??:vl explain as below.

My min X axis value=round(avg(strike_price1)-10,1) =75 at present.

So for 75 and 95 X axis values I want the min and max values of Y axis positions in the graph .

Basically,if you look into my chart at 75 x axis ,the Y values range from -20000 to 20000 and the rest is not required ie ranges  -1000000 to -400000 and 1000000 to 2000000.If the range is changed the lines will be much spead out and easier to view.now its getting concentrated .

So I want this part to be dynamic.There should be no empty range in Y axis.The min and max values (+-1000)  of the lines should become the min and max range of the Y axis in the graph dynamically when the selections are changed.

I wish this explanation is better to understand my requirement.Else please let me know,will explain again.

[#5]

Hi all,

Is my question still unclear??? or its complicated and could not be solved???

[#6]

Cant you just change your static min and max under Scale in Axes tab?

[#7]

Hi Thomas,

for X-axis???? but how would it help

[ThornOfCrowns]

Your "payoff values" range from 1,889,000 to -840,000 and your chart reflects this.

[#9]

Then i dont get your question- havent you changed ur x-axis?

[#10]

no,my chart ranges from -1000000 to 2000000...