Problem with line chart

[v_emilova]

Hi! I have a problem with inserting line chart. At the end I have to fixed x-axis with value 1 (I think so), so that values of two indexes (all of the are bigger that 1 and 0 doesn't exist) to be represented one above x-axis and the other, under it. Here is an example:

Thank you!

 

[RoryA]

Welcome to the forum.

If I understand you correctly, you can select the vertical axis, right-click and choose Format Axis, then in the axis options you can select at what point the horizontal axis should cross.

 

[v_emilova]

Thank you!
Yes, I tried this for disconnecing zero value, but unfortunately I can't insert second line (that under 1, which values are also bigger than 1).

 

[RoryA]

I'm afraid I don't understand what you mean?

 

[v_emilova]

Ok, I'm sorry! I have two indexes with values bigger than 1. These two indexes have to be represented with line chart (like the image in the first post). Lines should not intersect and have to be above and under axis with value 1. I can make two separate line charts but I can't make them all together.