I can't tell from your description what you want your end result to look like.
Can you mock up some sort of design? Or maybe explicitly describe the requirement.
If all you need is bucketed days pending then I'm not sure how reference lines come in to the picture...
1 of 1 people found this helpful
This is the closest I can get.
I needed to create discrete buckets for your condition.
I then had to convert the Days Pending to discrete as well so that the X axis made sense.
The downfall of this approach is that since Days Pending is discrete, the values aren't continuous so you'll only see an axis position when a value exists.
If this is an acceptable approach I can attach the workbook.
It's not quite what I am looking for, but it may be better than what I have! Can you post the workbook? Thanks!