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

Get our free Gantt chart Excel template to step up your project management game without investing in new software. Our template is 100% free and easy to use.

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.

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.