VBA developer

Job ID: 32820271

Budget: $10 – $30 USD

I have the same a worksheet with charts created in Excel 2012 and Excel 2016.
(It uses an addin to load the data and create the charts).

There are 2 issues I have.

1). In Excel 2016 the chart line (plot) does not show ( it does in Excel 2012).
I need to know why and what setting needs to be changed to make it show exactly as in Excel 2012.
I will be fixing this in VBA so I need the exact property to set.

2). In 2012 the line plot is a continuous line but in Excel 2016 it is not ( it is a broken line).
I need a continuous line so again I need to know why and what setting needs to be changed to make it
show as a continuous line as in Excel 2012. I will be fixing this in VBA so I need the exact property to set.

I will provide the same workbook from Excel 2012 and 2016 that show the two chart issues.
I expect a short report explaining what the issues are and what properties need to be changed to display the plot correctly.


Ideally I would like a very experienced Excel developer who can work on addin's, classes and complex charts/axis who can fix the issues with this VBA addin for me and do more work on it and possibly convert it to a compiled add-in.

Please let me know your experience with Excel VBA if any.
Related categories: Visual Basic Excel Visual Basic for Apps