This is the story of Vijay Agarwal, who received MVP Award from Microsoft on 1st of April.
Some of you know that I am a recipient Microsoft MVP award. It is an award Microsoft gives to software community leaders & contributors. Often people ask me, “Chandoo, how do I become an MVP?”. So today I want to tell you how you can become an MVP.
Around first week of April, I got an email from Vijay,
Hi Chandoo,
My self Vijay Agarwal from Delhi and I am a big fan of your site/articles. With blessing of God and inspiration from legends like you, I am pleased to inform you that yesterday evening I have been awarded Most Valuable Professional (MVP) award by Microsoft for my contributions in Excel.
This is the link of Microsoft site where it has been updated.
I congratulated him immediately. It is always a pleasure to see people succeed and get recognition for their efforts. I also asked him if he can share his MVP journey to inspire all of us at Chandoo.org. Vijay being an awesome guy, wrote and send it promptly. So here we go.
My ‘MVP’ Journey
1st April 2014, the day, which I would never forget in my life as Microsoft has awarded me Most Valuable Profession Award (MVP) for my Excel skills which undoubtedly is the ‘Nobel Prize’ in Microsoft community.
Can a person ever think of such a feat…,
- who spent his childhood in a very small town of Haryana (a state in India)
- who completed his graduation in Hindi medium only
- who never heard or saw a computer before his graduation
- who touched a computer only after completing his CA in 1993
Really really it’s a long story, how and when I fall in love with Excel even I don’t remember. I believe it was 1998. Being a Chartered Accountant and good in mathematics/logic I found myself spending more and more time on it and within few months, I was the ‘Excel master’ in my company. I never had any type of training on any of MS product, whatever I learn that was just by reading Excel help (its too good, that is written by experts, never ignore it), doing and doing and helping others. In the mean time, I moved to ERP/SAP line and also got lot of proficiency there, but, yes Excel was always with me. Till 2009, I used to get people coming to me for Excel queries, and used to got calls from my colleagues of previous companies.
I was not much involved on any type of forums on internet till 2009, then I became one of the members on http://answers.microsoft.com/en-us/office in 2010 and started to see people answering very tough/complicated questions. There are people who are more experienced and legends on these forums and moreover very good in Macros, me not a technical person, I hardly used macros, but being good in logic I started to answer questions even which people thought is possible through macros only, by building logic and providing non-macro solutions. It was not frequent, but my response also got “marked as answer”, and it was in 2012 last quarter that I was tagged as Star Contributor, after that I just got addicted to solve more and more questions, and the result is in front of you.
I don’t prefer Macro/array solutions much and always try to find some simple Non macro/non Array solutions which I believe users like.
I remember one quote of Steve Jobs here.
“Simple can be harder than complex: You have to work hard to get your thinking clean to make it simple. But it’s worth it in the end because once you get there, you can move mountains.”
While answering questions I try to make things simple and follow these rules.
- Will my solution meet the requirement of user
- Can it be more simplified/compact and made better
- Is there any alternate solution for this
- Is it user friendly
- Would it be better to provide Screen shots/File Link
- To the point/brief
- And then I try to follow all above rules while answering questions
I believe one should have passion/belief for a subject and then he will automatically find the time/ways for it. MVP is not the destination; I do it because I love it. It gives lot of satisfaction when one get compliments for your responses. There is no short cut to hard work. Do what you love and love what you do so that you don’t feel bored/burdened.
Beside Excel I am fond of yoga, give motivational speeches and travel.
I am thankful to God for giving me such a beautiful life.
Wish you all the best and feel free to get in touch with me thru my MVP page or Microsoft Answers page.
Thank you very much Chandoo for giving me an opportunity to write on your blog.
I learnt and learning a lot from Chandoo.org
keep it up, God bless you.
Thank you Vijay
Thanks Vijay for sharing your story and inspiring us. I agree with you that as long as we make our life about learning & sharing, it will be challenging and beautiful. Thanks for taking time to write for us. Many congratulations once again on the much deserved MVP award. Wishing you many more years as MVP.
If you enjoy Vijay’s story, please say thanks to him or congratulate him.
More on MVP Award
- Chandoo becomes MVP
- Hui becomes MVP
- Microsoft MVP Award website
- Chandoo.org Forum (to share your knowledge or ask a question)
13 Responses to “Gantt Box Chart Tutorial & Template – Download and Try today”
Hi Chandoo
As one of your students I have followed your detailed example through with great success. However, Excel is acting in an unexpected way and I wonder if you could take a look?
http://cid-95d070c79aef808e.office.live.com/self.aspx/.Public/Gantt%20Box%20Chart.xlsm
On my version, I have to type 40239 (Which equates to 2 Mar 2010) to get the chart to display 31 May 2010 (which should be 40329)!!??
Have I done something wrong or is Excel acting up?
Thx
Oli
PS Your example file in 2007 displays correctly.
Hi,
I like this idea a lot, but I agree the name is a little drab.
As an American I may just be seeing things, but to me the combination of lines and bars on your chart looks like a bunch of cricket bats.
Maybe you could work that into a catchier name. 🙂
Cheers!
Here is some code I use to keep the axis synched.
It may be useful to some of your readers
It is based on a comment I saw on Daily Dose of Excel.
Function SynchGanttAxis(Cname, lower, upper)
'Sets the X min and X max for Category axis
Application.Volatile
On Error Resume Next
'
'Top Horizontal Axis
With ActiveSheet.Shapes(Cname).Chart.Axes(xlCategory, 1)
.MinimumScale = lower
.MaximumScale = upper
End With
'Bottom Horizontal Axis
With ActiveSheet.Shapes(Cname).Chart.Axes(xlValue, 2)
.MinimumScale = lower
.MaximumScale = upper
End With
End Function
Function SynchVerticalAxis(Cname, lower, upper)
Application.Volatile
On Error Resume Next
' Excel 2007 only
'Right hand vertical axis
With ActiveSheet.Shapes(Cname).Chart.Axes(xlValue, 1)
.MinimumScale = 0
.MaximumScale = upper
End With
End Function
@Oli.. Can you check your file again.. I see 40329...
@Dave: Even I saw things.. the bars actually looked like lollipops. How about calling this lollipop chart - now that would be yummy and goes along the tradition of naming charts after eatables (bar, pie, donut...)
@Bob: Superb stuff... thanks for sharing 🙂
Hi Chandoo
This looks really good and I think it can also be applied to show project phases / milestones.
Question: Thinking further could this be amended to display a project lifecycle (Idea through to Implementation say 7 phases) on one bar / row? Just imagine 20 projects within a programme all on one chart one bar each showing their respective lifecycle stages i.e. on one page.
Idea: As the Gantt Box Chart this is quite intensive to set up re formatting etc how about the added extra of once you have completed this to "Save as template" i.e. saves the formatting and layout of the chart as a template so you can apply to future charts. Simple to do and will save the time formatting etc again and again and again.
Therefore tip: Click on your chart demo and then click on Save As template icon (2007) - edit file name and click on save. Ready to use / apply via Templates in Change Chart Type window.
Thanks and be very interested if the lifecycle question can be resolved
Mike
How embarrassing.
I was obviously suffering from numerical dyslexia. I was one of those days.
@Mike H: You can easily make this chart to work like a generic project lifecycle plan chart. All you have to do is,
1. in a separate sheet define the steps of lifecycle and various dates in a table (with 5 columns for each of the projects you have).
2. now use a control cell to input the project name you want to show in the chart
3. based on the input, use OFFSET Formulas to get the correct data
4. Rest is same as the tutorial above
For more info on the dynamic charting visit http://chandoo.org/wp/tag/dynamic-charts/ and http://chandoo.org/wp?s=OFFSET
Your solution is really smart but in the en Excel isn't meant to do stuff like this. I, as a former PM, always thought is was frustrating that you had to do stuff like this for something simple like a Gantt chart. So I built Tom's Planner. And would like to plug it here. I think it really solves the problem you are trying to solve in the most efficient way. Check out http://www.tomsplanner.com for a free account or play around with the demo.
Hi there,
Chandoo - this is really a very nice and helpfull chart - I adopted it, so I can report a forecast or the delay of a certain task (coming from my role as an auditor for projects).
One topic I´m currently struggeling with: I do have a project lasting for lets say 12 month. For a management reporting, I want to have kind of snapshot, lets say one month back and 2 month in the future. I tried with the offset formula, but failed. Any idea?
Thx
Lopi
[...] Ein viel geliebter Klassiker ist die Erstellung von GANTT-Diagrammen mit Excel. Wir hatten das Thema wiederholt schon hier. Chandoo.org hat sich mal wieder mit einer neuen Variante hervorgetan: Das GANTT-Box-Chart. [...]
[...] [...]
Hi Chandoo - fantastic xls. One thing I can't figure out how to do is adjust the alignment of the vertical axis. I would like to left align so that I could indent to represent sub tasks. Can that be done? Or is there a better way?
I've been trying to work out if there's a way to show weekends on the graph. The closest thing I've got is to add them on a secondary axis, but then I haven't been able to keep both axis lined up together! Any ideas?
Following on from this - is it possible to show things like holidays?