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 ...

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!

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

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.