I'm trying to find a solution to a problem that I have with my data.
In my data series, I have Temp over Time plotted on a scatter graph in excel. The data plots a period of around a week in the beginning of February and a week at the beginning of March. This leaves a massive gap in between the data sets and pushes the plotted information to the edges of the graph.
I've found loads of threads on forums asking this question, but none seem to have found a solid solution to the problem.
I've also tried creating a panel chart to eradicate the time gap, however, of the 3 different ways I've tried, none seemed to have worked for me as it doesn't seem possible to add a secondary X axis on my graphs.
Any help would be greatly appreciated.