4 Replies Latest reply on Sep 18, 2018 10:57 AM by pablo.escalera

    How to line chart with three different lines

    pablo.escalera

      I am trying to create a line chart that displays three lines. My understanding is only two measures can be combined as a dual chart. So I figure in order to to this I need to reshape my data somehow and place a dimension in the Color marks and that would then split the values by the dimension. I am uncertain on the best way to do this. I attached a sample Excel dataset that contains how my data is shaped currently on the "Current dataset" tab and an "Updated" tab that displays how I think my dataset needs to shaped in order to get the result that I am looking for. Also attached is a sample workbook that demonstrated my problem, using the Excel file as the data source.

       

      Thanks!