I have implemented a neural network for load forecasting in Microsoft Excel. My structure is very simplistic and involves only 1 hidden layer and 4 neurons. (See picture)
I trained my network with a very large set of data and the predictions are as decent as could be expected. However, when I go to try and predict the "future" using recent data, the network is only in the ball-park, not very close at all. Here is a plot of the actual numbers versus the forecast ones.
From looking at this chart, can it be determined if I need another layer or more neurons??

