Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Line Diagram

Copper Contributor

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!

2 Replies

@JuliaBAE 

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!