Завершено

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.

Квалификация: Excel

Показать больше milestone trend analysis excel template, milestone trend analysis mta excel, milestone trend analysis excel, milestone trend graph excel, works need excel, why graph data, why graph, vertical lines and horizontal lines, needs analysis, milestone management, microsoft excel management, june is the month for, i need microsoft office, graph links, graphing of data, graphing in c, graphing data, graphing and data, for the month of june, excel line graph template

О работодателе:
( 1 отзыв ) Longmont, United States

ID проекта: #5880694

Поручен:

                                                    Systems3000
                                                's Profile Picture"                                                    >
                                                </a>
                                            </figure>
                                        </div>
                                        <div class=
Systems3000

Hi, I've done extensive Excel charting for investment banks so the MTA charting would be very straightforward. Almost all chart properties are available to macros using VBA (Visual Basic for Applications) so all the fe Больше

$100 USD за 3 дней(-я)
(1 отзыв)
0.9

12 фрилансеров(-а) в среднем готовы выполнить эту работу за $162

sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [login to view URL] Looking for further discussions in this matter. with than Больше

$194 USD за 6 дней(-я)
(32 отзывов(-а))
5.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive Больше

$100 USD за 3 дней(-я)
(34 отзывов(-а))
5.1
tomislav1975

Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom

$183 USD за 7 дней(-я)
(6 отзывов(-а))
3.8
aarifakhtar

A proposal has not yet been provided

$166 USD за 4 дней(-я)
(8 отзывов(-а))
3.6
Nebuchadnezzan

been working with project management excels and charts for over 10 yrs now.... understand the requirements and ready to do it. Bidding with the minimum price to build a relationship.

$30 USD за 3 дней(-я)
(5 отзывов(-а))
2.9
semaj0220

I am a Quality and Data Analyst and most of the work that I am doing involves creating and automating reports using MS Excel Macro and VBA. I've checked the template and we can definitely do something in automating the Больше

$250 USD за 3 дней(-я)
(3 отзывов(-а))
2.7
GuruExcel

I am Excel Expert and have done numerous projects. I have good macro skills. I have understood your requirement a bit. I am available and can help you with your task. Message me if you want to discuss the project.

$250 USD за 3 дней(-я)
(6 отзывов(-а))
2.5
arunpr26

Hi Greetings!! Having 4+ years’ experience in data analysis, data modeling and data entry in Excel. Placed a few documents in my portfolio, please have a look on those to get an idea on my skillsets and the quality. Больше

$111 USD за 3 дней(-я)
(1 отзыв)
1.9
nikhilgupta84

Hi, I am Nikhil Gupta. I am having total 9 years of extensive experience into Analytics. I rarely bid on this website. However, I am planning to be active on this website. I worked on tools like Excel, SAS & SPSS. Good Больше

$155 USD за 3 дней(-я)
(2 отзывов(-а))
1.4
ABHAYS1983

A proposal has not yet been provided

$155 USD за 3 дней(-я)
(3 отзывов(-а))
1.0
gerampo

Dear Sir, Greetings! I am interested to work in your project. I have here a sample MTA Graph in Excel. Please look unto it. I can still incorporate improvements on that excel file if you wish to. This Excel MT Больше

$244 USD за 3 дней(-я)
(1 отзыв)
0.8