You can create a calculated field and then create a reference line of that value.
Does that help?
Can you post your workbook?
Hmmm. That's certainly more complex than I was imagining.
Is your x-axis continuous? Could you make it discrete?
Maybe you could use something with WINDOW_MAX and WINDOW_MIN...
Can you share your workbook?
x-axis needs to be continuous... I can't really share the workbook.
These are two different data sources, otherwise I feel like I could perhaps use a bar chart or something to draw the lines.
Thinking about it more, it would be REALLY nice if they'd just add a "Reference Line" shelf, which could then be multiple marks or an aggregate mark.
Not possible then...?
I don't have a solution for you on this one... I'm not prepared to say it's not possible.
So I ended up doing this in a really wonky way by doing a UNION of the two datasets and putting the start/finish times are the second Y axis as a bar (0 or 1).
I'd much rather have a shelf for reference lines, specifically that works on a date axis
edit: grrr - wish I could merge my corporate account w/ my personal acct - I am Kyle B from above