I have a cumulative line graph with planned and actual series. Y axis = cumulative currency, X axis being months of the year. I want the actual series to only display the line up until the current date, and not show the line after that date. I have a variable month number, and when this changes to month 2 the line should only show up to month 2 (currently it continues in a straight line, which is not desirable....)
Any suggestions on how I should attempt to solve this one??