Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Split and graph problem
To all,
I have a set of data in two columns A: A, and B:B( Sheet name DATA ). The A column contains times, and the B column contains temperatures: i.e: 13:14:39 949 13:15:39 949 13:16:39 949 13:17:39 949 13:18:39 949 13:19:39 949 13:20:39 949 13:21:39 949 13:22:39 949 13:23:39 949 12:53:26 819 12:54:26 819 12:55:26 819 12:56:26 819 12:57:26 819 12:58:26 819 12:59:26 819 13:00:26 819 13:01:26 819 13:02:26 819 13:03:26 819 13:04:26 819 What I want to do is split the data if there is a difference between two adjacent times of greater than 10 minutes. So for example where I have put a line break in the data - this is where it would be split. I then want each 'split' set of data to be put in a new worksheet, and a chart created for each set of data. The number of splits can vary for each set of data. Is this possible? Thanks to all in advance, Kind Regards Joseph Crabtree |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem Printing Excel Graph -data doesn't show up when printed | Charts and Charting in Excel | |||
Can you make a "split" or broken y-axis on a graph in Excel? | Charts and Charting in Excel | |||
How do I split the axis scale on a line graph | Excel Discussion (Misc queries) | |||
how do you split the scale (x-axis) on a curve graph? | Charts and Charting in Excel | |||
Split large bar in a graph? | Charts and Charting in Excel |