Thanks for your response.

The first attachment shows the graph as it should look. This has been achieved by cutting and pasting to separate different types of data manually instead of using the formulas to do this.

The second attachment shows the data itself. ‘All Reading’ are separated into their different types (‘AM’,’ PM’, ‘Post Exercise’ and ‘Routine’ for both AM and PM reading). This is to enable further analysis of the different types of data independently.

The third shows a graph where the ‘Routine Readings’ data is not where it should be. Only one data point is present at the second ’00:00’ point as this signifies ‘1’ on the x-axis. It also shows (1,550) instead of (10:40,550) for a correctly placed data point.



Hope this helps.

Attached Images

	Excel 1 - good graph.jpg (37.7 KB, 14 views)
	Excel 2 - Data.jpg (59.6 KB, 13 views)
	Excel 4 - Bad Graph.jpg (36.8 KB, 12 views)