I'd like to display target values as a line (Plateau - leading). These values keep changing over time, and these changes need to be shown on the graph as well (which is why I couldn't use Reference lines).
If the target value was last changed on the 605th day, the line stops there despite the actual values being available for 900+ days after. How do I get the target line to keep extending beyond the 605th day for all days that actual values are available for?
I've attached sample data with the number of days.