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, create line plot, be smith, excel chart code, automate excel weight chart, weight, vba e, vba code excel, smith, line sheet, excel charts, excel automate, create excel worksheet, excel 2011 vba, chart plot module, charts excel, sheet excel visual basic, automate excel code, chart line, chart example, vba excel 2011, vba 2011, create workbook, automate number

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