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.

We list useful Excel Project Management Templates that will help you with Tracking. Excel allows you to calculate data with formulas, use graphing tools, build charts, etc.

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.