I am trying to reproduce a visual that I created before, however, the formatting of my data has been requested to be streamlined and easier for automatic updates. My original data and visual looked like this:

Now my data must look somewhat like this where an initial and final value are together on one row instead of separate rows. Will it even be possible to reproduce the visual? The only way I can imagine it working is if Excel reads in a zigzag way down C and D.

​I am trying to reproduce a visual that I created before, however, the formatting of my data has been requested to be streamlined and easier for automatic updates. My original data and visual looked like this:Now my data must look somewhat like this where an initial and final value are together on one row instead of separate rows. Will it even be possible to reproduce the visual? The only way I can imagine it working is if Excel reads in a zigzag way down C and D.     Read More

​