Chart problem with data setup. Only want to see actuals to current date.
In the attached chart you can see that I only want the chart to show actual data up to the current date. Don't want to show future "blank" data. Want horizontal chart to end at current date. Please advise.