7 Replies Latest reply on Jan 23, 2017 7:24 PM by Dennis Liu

    Line Chart - Blending Actual with Forecast and plot against Budget

    Sujay Paranjpe

      Hello All,

       

      I have data for financial year and there are 3 pieces of information. My Fin Year is July to June

       

      1. Budget for each month

      2. Actual until the latest reporting period.

      3. Forecast for all the months after reporting period.

       

      For example (assuming Dec Actual numbers are reported):

       

      MetricJul-16Aug-16Sep-16Oct-16Nov-16Dec-16Jan-17Feb-17Mar-17Apr-17May-17Jun-17
      Budget200300400300100200300200400300200100
      Actual232275396575200345
      Forecast25015035025015050

       

      I need to build a simple line chart with following requirement.

      1. Trend line for the budget for full year (12 marks) with blue color

      2. Single trend line for actual and forecast (6 marks each) with actual in grey color and forecast in green color.

      3. Both these lines on a single line chart, of course :-)

       

      P.S. I actually want forecast to be dashed line or dotted line but I am aware that Tableau cannot draw dashed lines.

       

      Best,

      Sujay