I have 17 tables of data showing a dollar balance over an approximately 10 year period. I want to plot all of the data on the same chart. The problem is that there are no gaps in the data, and the graph will plot based on an occurrence, rather than the time period. I need all data from all tables to be aligned and showing data relevant to the time period.
I've attached a photo showing the current problem with the plot, none of the plots align to the 10 year time period. All charts run for the same time period, so if there is no data then the balance will remain the same, as neither a profit or loss occurred on the account.
I'd like someone to correct the data (if required) and create the graph.