View Single Post
 
Old 11-13-2012, 01:48 PM
Ady_E Ady_E is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Nov 2012
Posts: 4
Ady_E is on a distinguished road
Default Attachments

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
File Type: jpg Excel 1 - good graph.jpg (37.7 KB, 14 views)
File Type: jpg Excel 2 - Data.jpg (59.6 KB, 13 views)
File Type: jpg Excel 4 - Bad Graph.jpg (36.8 KB, 12 views)
Reply With Quote