Using Excel’s trendline chart, you can easily forecast based on your current performance.
Be it a Weight-loss program or a Sales performance, Trendline chart comes in handy.

The choice you got to make!

The choice you got to make!

It’s awesome that you have taken a weight-loss resolution on new year’s and are actually following it!
Let’s see how will fare based on your current performance!

Make data in an Excel sheet as shown below.

Data structure

Data structure

  • Month – Mention the month number.
  • Goal – This column should have your overall goal, in this case, 20 pounds.
  • Actual – At the end of each month, enter your Actual weight lost (from the beginning).

Steps to create the chart

  1. Select the Goal and Actual columns (do not select the month column).
  2. Go to Insert Tab, select a 2D Line Chart. You will get the below chart.

    2D Line chart

    2D Line chart

  3. Select the Actual line, right-click and choose Add Trendline…

    Add trendline

    Add trendline

  4. Under Trendline Options tab, Choose Linear style of the trendline.

    Linear Trendline

    Linear Trendline

  5. Under Line Style tab, make the width 1.25pt and change the Dash type.
    Dashed

    Dashed

     

Thus, the final chart will show the forecast as below,

Final Forecast

Final Forecast

 

Need to buck up! You can still make it to your goal 😉