# Cumulative distance between intercept points on Excel graphs

##### New Member
Hi there, hoping you can help with the following:

Looking at the chart below, it is possible to use an excel formula/VBA to calculate the cumulative time below a certain value of x (as indicated by the arrows I've added to the chart)?

NB The graph shows the variation in tide height (x) over time .

The graph looks like this:

The data looks a littles something like this : (extract)

Really stumped on where to begin with this one; any suggestions or input would be very gratefully received.

Stuart

(Excel 2007 & Windows Vista)

Last edited:

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Assuming you have the actual recorded data and not just the curve, this will work:
Book1
ABCD
1Levels of interest:42
2Date/TimeTideMinutes aboveMinutes below
3
43/7/09 4:30 AM2.5700
53/7/09 4:36 AM2.5200
63/7/09 4:42 AM2.4700
73/7/09 4:48 AM2.4300
83/7/09 4:54 AM2.3900
93/7/09 5:00 AM2.3500
103/7/09 5:06 AM2.300
113/7/09 5:12 AM2.2600
123/7/09 5:18 AM2.2200
133/7/09 5:24 AM2.1800
143/7/09 5:30 AM2.1300
153/7/09 5:36 AM2.0900
163/7/09 5:42 AM2.0600
173/7/09 5:48 AM200
183/7/09 5:54 AM1.9406
193/7/09 6:00 AM1.92012
203/7/09 6:06 AM1.88018
213/7/09 6:12 AM1.84024
223/7/09 6:18 AM1.8030
233/7/09 6:24 AM1.76036
243/7/09 6:30 AM1.73042
253/7/09 6:36 AM1.71048
263/7/09 6:42 AM1.65054
273/7/09 6:48 AM1.62060
283/7/09 6:54 AM1.59066
Sheet1

Graphing it could look like this, if you add some "dummy" columns to differentiate between the normal tide levels and your extremes:

Last edited:

Replies
5
Views
461
Replies
0
Views
283
Replies
3
Views
2K
Replies
1
Views
640
Replies
1
Views
2K

1,207,423
Messages
6,078,443
Members
446,339
Latest member
keogata

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back