Produce a VBA module which the user can run via a button located on the Players worksheet. This will create a Weight Tracking Chart for individual players in a team. In the example file there are two players, and thus 2 charts are needed, one for John Smith and one for Mike Carter.
The VBA code needs to anticipate a variable number of players and produce as many charts as there are players.
Each player will have their weight checked approximatey every 6 months with a new row added to the 6-month updates sheet. The VBA code needs to locate all the weight values associated with an individual player, and plot these in a line chart.
On the chart - Y-axis to show weights. X-axis to show dates. It is not necessary for the x-axis to be scaled, the dates can be considered values/labels. The title of the chart should include the Players Name e.g. "Weight Tracking : John Smith"
Charts created as separate tabs within the workbook.