Forum Discussion
Line Diagram
Line diagram: I want to draw a line that stagnates at a certain value. Let's say the value is in cell B2. How do I do this? Thanks for your help!
If I interpret your question correctly:
Let's say the y-values for the line chart are in K2:K50.
If necessary, insert an empty column in column L.
In L2, enter the formula =MIN(K2, $B$2)
Fill down to L50.
Use L2:L50 in the chart instead of K2:K50.
Thanks a lot!