The P/E bands of this template is similar to what Peter Lynch used in his research, except that in his chart, the Earnings Line was drawn at P/E=15. Warning!

If you create a lot of charts in Excel, you should definitely be creating and using your own chart templates. It helps keep the look of your charts consistent and will save you a ton of time.

Gantt charts are one of my favorite ways to gain visual project overviews. Whether you use Google Sheets or Excel, you can enjoy using several beginner-friendly templates for work, studying, and ...

Locate the template in your downloaded files. Note that it is saved under a file name that includes a string of letters and numbers such as "TSI01877515" for the chart-only Excel 2007 template.

Before and after: Your turn! I mentioned at the beginning of this article that you’ll get the chance to practise. Using this handout and the Excel chart below about speed skating at the Winter ...

We are very glad to let you know that we have created a new Excel Peter Lynch Chart template that illustrates the valuation bands based on the historical median P/E, P/S and P/B ratios.