7 Replies Latest reply on Jan 31, 2019 1:30 PM by Tim Hart

    Splitting data to create a line chart comparing 2017vs2018




      I am working with car accident data and I am trying to compare the rate of car accidents vs the damages of car accidents per year. In my attached photo you can see accidents vs damages for 2017 vs 2018 however I would like to split the data to show two lines for all 2017 data and two lines for all 2018 data - essentially having four lines total on one graph. Right now the data is comparing accident and damages for 2017 vs 2018 but i'd like it to compare accident 2017 vs accident 2018 vs damages 2017 vs damages 2018.


      Let me know if I can provide further info.