In Progress

Automate Excel weight chart

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.

Skills: Excel, Visual Basic

See more: excel weight, weight excel, x-axis, create a line plot, create a chart, be smith, excel chart code, automate excel weight chart, weight, vba excel, vba e, vba code excel, smith, line sheet, excel charts, excel automate, create excel worksheet, automate], excelchart, excel 2011 vba, chart plot module, charts excel, sheet excel visual basic, automate excel code, chart line

About the Employer:
( 1 review ) Brighton, United Kingdom

Project ID: #1138961

Awarded to:

FIBIN

Hi I am interested to work in this project. I have worked on similar prjects including automatic chart creation. Please see my PM. Thanks Fibin

£20 GBP in 1 day
(54 Reviews)
5.4

9 freelancers are bidding on average £30 for this job

vserv

Pls see your messages. Thanks

£40 GBP in 3 days
(64 Reviews)
5.9
fedalal2

Hi, I have more 10 years experience in MS Excel include VBA, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

£40 GBP in 1 day
(33 Reviews)
5.5
vbexcel

Excel VBA expert.

£50 GBP in 1 day
(31 Reviews)
5.6
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

£20 GBP in 1 day
(20 Reviews)
5.0
microk

Let's start..

£20 GBP in 0 days
(31 Reviews)
4.4
RafalL

Hello. I can prepare such workbook for you, fast and reliable.

£40 GBP in 1 day
(2 Reviews)
4.0
habayabah

For your consideration.

£20 GBP in 0 days
(3 Reviews)
3.1
dineshmhatre

You need a simple solution attached. rest described in PM

£20 GBP in 0 days
(0 Reviews)
0.0