Hi Folks.
Is there a way to chart (see data below) the "Original SA #" as one line attached to the "Original SHSD Ready Date" and the "Current SA #" as a second line attached to the separate date series "Current SHSD Ready Date" all in one chart so it aligns as a single time series on the horizontal axis?
<colgroup><col span="3"><col span="3"></colgroup><tbody>
</tbody>
Is there a way to chart (see data below) the "Original SA #" as one line attached to the "Original SHSD Ready Date" and the "Current SA #" as a second line attached to the separate date series "Current SHSD Ready Date" all in one chart so it aligns as a single time series on the horizontal axis?
Original SA # | Current SA # | Actual SA # | Original SHSD Ready Date | Current SHSD Ready Date | Actual SHSD Ready Date |
362 | 332 | 9/5/19 | 11/29/19 | ||
437 | 437 | 1/24/20 | 3/7/20 | ||
430 | 396 | 396 | 9/15/19 | 9/8/19 | 9/8/19 |
51 | 53 | 12/4/19 | 1/23/20 | ||
117 | 117 | 12/12/19 | 1/30/20 | ||
295 | 441 | 12/27/19 | 2/13/20 | ||
170 | 182 | 1/13/20 | 2/26/20 | ||
230 | 248 | 11/5/19 | 3/10/20 | ||
564 | 569 | 4/8/20 | 3/20/20 | ||
282 | 279 | 5/4/20 | 3/31/20 | ||
561 | 563 | 7/13/20 | 4/10/20 | ||
476 | 472 | 7/30/20 | 4/21/20 | ||
356 | 371 | 7/1/20 | 5/7/20 | ||
430 | 441 | 4/27/20 | 5/21/20 | ||
423 | 510 | 5/13/20 | 6/4/20 | ||
491 | 503 | 4/16/20 | 6/16/20 | ||
489 | 486 | 3/9/20 | 6/30/20 | ||
287 | 296 | 6/2/20 | 7/30/20 | ||
345 | 368 | 7/1/20 | 7/30/20 | ||
343 | 345 | 7/16/20 | 7/30/20 | ||
348 | 337 | 6/4/20 | 7/30/20 | ||
431 | 435 | 6/17/20 | 7/30/20 | ||
638 | 652 | 6/22/20 | 7/30/20 | ||
574 | 624 | 6/3/20 | 7/30/20 | ||
403 | 472 | 6/24/20 | 7/30/20 | ||
352 | 274 | 6/10/20 | 7/30/20 | ||
508 | 543 | 6/8/20 | 7/30/20 | ||
481 | 460 | 6/4/20 | 7/30/20 | ||
540 | 578 | 3/2/20 | 7/30/20 | ||
597 | 659 | 3/4/20 | 7/30/20 | ||
427 | 589 | 4/30/20 | 7/30/20 | ||
405 | 400 | 5/1/20 | 7/30/20 | ||
516 | 516 | 6/12/20 | 7/30/20 |
<colgroup><col span="3"><col span="3"></colgroup><tbody>
</tbody>