6 Replies Latest reply on Jun 28, 2018 5:50 AM by Jim Dehner

    How to formulate line graph to worse and best with own data

    Pak Hang  Leung

      Hi all

       

      Now I have an workbook, which consists of month data, Actual revenue until May 2018, and worse and best scenario for the remaining year.

      What I want to do is to formulate the graph similar to this:

      That is, after the actual data May 2018, split the line graph into 2 based on the values in column worse case and best case.

      I tried to google it but cannot find a similar case. Would it be possible to do so?

      The workbook is attached as your reference. Many thanks!