Need a "Milestone Trend Analysis" graphing tool built in Excel

I have a template for a "Milestone Trend Analysis" excel template that works OK, but needs tweaks.  I don't have the skills to modify the sheet.  I believe the skill you need is to be really, really good at understanding and manipulating charts in Excel.  Maybe you'll need mad macro skills.  Don't know. 

This is the template I have been using and is "almost there", but not quite.  Which is why I need you!

[url removed, login to view] (tool 3)

Here are other links that describe the tool:

[url removed, login to view]

[url removed, login to view]

Deliverable requirements:

1. Data represented in MTA graph will come from a "data cube" that would allow filtering of data via slicer in pivot table or filter in the data cube itself.  I have a portfolio of about 12 projects, with upwards of a dozen milestones in each.  So let's say up to 200 milestones total.  I would usually filter one project at a time, but I do want an overall MTA that would show all milestones.

2.  I would be able to easily add or delete milestones at any time.

3. I want data points weekly, but I only want the axes grid at the Month resolution.  In other words, I want the grid lines to be at May 1st, June 1st, etc. even though the data points have greater resolution.

4. Graph should have lines connecting data points and lines should big, bold and visible.

5. Axes should automatically scale  to include only the range of dates in the filtered/selected milestones.

6.  Horizontal and Vertical axes must be symmetrical (identical ranges).

7. Graph must have a diagonal line that represents the "milestone reached line."

8. Legend should show the Milestone name, the original "baseline" date, and the current "forecast" date.   

9.  Option to "turn on" labels for lines (when there aren't too many milestones selected).  Like the legend, the label should have name, baseline date, forecast date.

Taidot: Excel

Näytä lisää: milestone trend analysis mta excel, milestone trend analysis excel, milestone trend graph excel, milestone trend analysis excel template, milestone trend excel, milestone trend chart excel, automate excel graphing, excel factor analysis, excel fetch data web site need log, guifront end onto existing business model built excel, java drawing tool built, automating excel graphing automatically, excel graphing day comparison, excel aging analysis, vba code excel data analysis

Tietoa työnantajasta:
( 0 arvostelua ) United Kingdom

Projektin tunnus: #13067239

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


“Budget and project period are flexible to meet to your requirement” I’m an Electrical Engineer. I am very interested in Web search and data input task and also i have a good experience in this field. I am responsib Lisää

$100 USD 2 päivässä
(39 arvostelua)

Technical writing is my area of expertise; I am confident about. I guaranty professional quality work with surety of flawlessness on pertinent technical information. I mobilize all my resources to bring about a perfect Lisää

$155 USD 3 päivässä
(0 arvostelua)

A proposal has not yet been provided

$155 USD 3 päivässä
(0 arvostelua)