Visit Us On Facebook

Visit Checkbook on Facebook

Visit Us On Facebook

Visit Handicap Manager on Facebook

Golf Tracker for Excel Help

 

 

Preparing Trend Charts

The Trend Charts tab in the Report Chart form provides fourteen different line charts to trend your report data. Just select the chart you wish to display and click OK. Here is an explanation of all the trend charts.

Trend Chart Form

On Trend Charts, each data point represents a single round of golf, or a running average of several rounds of golf. You can designate how many consecutive rounds to average together for the chart data using the Rounds to Average setting in the Running Averages for Data Points section of the Report Charts form. If you set this value to 1, each data point on the chart represents one round of golf. If you set the value to 2 or higher, the program use a running average of that many rounds for each data point. The default value is 3, so using that as an example, the first point would average rounds one through three, the second point would average rounds two through four, the third point rounds three through five, etc. This provides a smoother trend that does a better job of representing a golfer's progress over a longer period of time.

When creating Trend charts, you can choose to display comparison statistics for an average PGA tour pro, a typical scratch golfer, or an average golfer by selecting the appropriate check box and option button in the Chart Comparisons section. (This option is not available for some charts as the data was not available or it didn't make sense for that particular category.) The PGA tour pro statistics reflect the data for the average of all players on the PGA tour in 2022. The scratch golfer statistics reflect the capability of a golfer with a 0 handicap index and the average golfer statistics reflect the capability of a golfer who shoots in the mid-eighties. These comparisons allow you to track your progress as you strive to become a better golfer, or even a scratch golfer. Keep in mind that the PGA tour pros play on extremely difficult courses so there's no reason you can't strive to match their abilities on the typical golf course, especially in the approach, short game and putting categories.