I'm sure this must be very simple but I'm going round in circles trying to make this work.
I have a table of values broken down into quarters of a day e.g. 01/07/2014 06:00, 01/07/2014 12:00, 01/07/2014 18:00, 02/07/2014 00:00, etc and I'd like to build a simple line chart that shows the sum of the IN and OUT numbers but only show a single dimension label by day but have four data points between each day.
So currently I have this:
And I'd like something like this (ignore that it shows a label every four days as excel wouldn't let me break down a day into 4 segments)