Plotting Data from Multiple Columns

I am trying to plot values associated with dates in 2 different tables. One table has historical values on historical dates and the other table has forecasted values on a futures date. I can join these tables with unique relations but when plotting on a line chart teh dates will be limited to only those that exist in the parent table. Future dates that are not in the Historical table will not be shown. Is there a way to get both data sets fully displayed?


Image icon spotfirecapture.png115.55 KB

(1) Answer