This content has been marked as final. Show 2 replies
Suppose that I have a table like this:
|Start Date||End Date||Value|
Note that durations described by the Start Date and End Date columns can (and do) overlap with each other.
I would like to visualize this as a series of lines with "Value" on the y-axis and date on the x-axis. I would like a line to start at value 23, date 1/1/2015 and end at 6/1/2015. Then, repeat that for each row with a new line.
(In real life there's another column that I'll use to turn the lines different colors...but that part is easy).
Any tips or suggestions?