There is an Easter Egg in Excel!

Share

Facebook
Twitter
LinkedIn

Did you know that MS Excel has a hidden, life altering Easter egg? This is a story of how I found it and discovered joy. Read on.

Almost an year ago, I have quit my job with one of the leading IT companies in the world, to embark on an uncertain but very exciting journey. I have started my own business around MS Excel – creating & selling awesome Excel products & training programs [visit our online store].

This is a continuation of the Chandoo.org Start-up Story posted around the same time last year. Grab a cup of coffee and read it in leisure. Do not expect any Excel tips. 🙂

[PS: if you are new to Chandoo.org, Read this and this before reading this post.]

There is an Easter Egg in Excel

What is it like to run a small business

When I wanted to leave a stable & well-paying job & start a business several things bothered me. What if my business never picks up? What if I do not generate enough money to sustain my family? What if I grow complacent & make mistakes? What if I get bored or lonely or get demotivated? What if I cannot handle the thousand little things that go in to running a business?

They say, leap and a net will appear. And leap I did. And just as if a switch is turned on, I found answers to all my doubts one by one. I discovered the joy in running a small business around my passion. I made mistakes, but I kept learning. I found help from friends. I made new friendships. I learned how to reduce, automate, outsource areas of work that are not critical. I hired people to help me with customer service & emails. And not one moment, I felt tired, bored or demotivated. In fact, I feel excited every single day about what I am doing.

How is my business doing?

Here is a quick summary of the business:
(April 2010 to March 2011)

  • Total paying customers: 2,175 (Repeat customers: 175)
  • Revenues: ~$200,000
  • Top products – Excel School (743), PM Templates (1148), Dashboard Training (199)
  • Consulting clients – Microsoft, Wao Marketing, eNor and more.
  • Speaking & Training – Office 2010 Launch Event, International Excel Workshop @ Maldives
  • Total Visitors to Chandoo.org – 2.5 Mn
  • Visitors who spent more than 15 minutes on site – 787,000
  • Number of comments received – 7,790
  • Number of articles written – 217
  • Press Coverage – MSN, Economic Times etc.

What did I learn in one year of doing this?

Many things. Hardly a week goes by without picking up some new skill or idea. But the most important things have to be,

It is not risky: I had this notion of taking huge risk by leaving a plush job. But then, the risk magically disappeared on day 2. Instead, I see immense opportunity for fun, knowledge, satisfaction and profit. All of which were not possible with my day job beyond certain extent. [Related: Is it scary to start?]

It does not take 80 hours per week: During the first 6 months, I used to work a lot. Most of the time I was inefficient. Then, I analyzed my time (in Excel, what else) and found that I could reduce the number of hours spent on e-mail and other activities to focus on what I love most – Excel, interacting with people and sharing new ideas. Now, I am spending <6 hours per day and I am happy with the results.

You need a supportive family: At least once a day, my son or daughter would walk up to my office-cum-guest-bedroom and knock on the doors, often violently, and scream – “daddy, da.” (meaning, Come out Daddy). Although, my heart would race to go out and hug them, I would say no and continue working.

There were days, when Jo (my wife) would feel lonely as I was locked inside the office room for a product launch or marathon recording session or crafting a dashboard etc.

Kids on Christmas Morning...

But, thankfully, I have an understanding wife. So, they would be all smiles when I walk out. Also, I have learned to structure my working hours around my kids sleeping hours. For eg. I would get up at 4AM to do recording.

Saying NO is 100 times tougher than saying YES: While I feel immensely thankful for the growth in my business, it has also bought in a new challenge. There were too many opportunities. So many more than I can handle. I get requests for consulting, training, product development, testing, collaboration and more. Initially I used to say YES to everyone. Soon, I had a pipeline of things to do, with no clear plan on when I will finish everything. Then, I started being picky. I started accepting consulting work for projects which are challenging. I started collaborating with one company at a time. This reduced the workload. But the challenge of saying NO is so much more than YES.

Taking it easy is not so easy: When this blog was my side-business, I used to take it very easily. But during the initial months of making the switch, it was hard for me to take this easily. I would freak-out when my site went down, when a customer dis-liked my product or when I get an email with “Urgent” in the subject.

I learned to slow down things. For eg. I reduced the number of posts per week from 5 to 3. I also roped in more people. Hui, Paramdeep & a few guest authors to write on this blog. Ravindra to help me with emails & customer service. Naturally, this restored my sense of humor and ability to learn new things.

Ask and you shall receive: This is the most important lesson. I used to worry whether anyone would purchase my training or products. But then I realized that by just asking you to purchase, you would consider it. This is how I was able to generate revenues from Excel School, PM Templates and other products.

What next?

The road is waiting...

I am excited about the way my business has turned out. While I generally avoid from making long-term plans, here are a bunch of things I would continue to do,

  • I would like to grow this business slowly and learn new things all along.
  • I will continue to share my knowledge, mistakes and ideas with you.
  • I will spend a great deal of time with Jo and kids. I love taking long walks with Jo, playing with kids.
  • I like connecting with people all around the world and will continue to do so.
  • I will continue making awesome products, training programs.
  • We (our family) will continue to spend less, live meaningfully and give back a portion of what we make to society.
  • I will continue to treat you, my dear reader, as my top-most priority.

Wishing you a happy Easter

I found an Easter egg in Excel. Instead of finding it on Easter day, I find it everyday. And I feel excited, fulfilled, grateful & honored.

I wish you will find your Easter egg. It might be in your profession, hobby, religion or community. I wish you will discover the same joy as I did and continue to spread it.

And if you have already found it, then I feel very happy for you.

Thank you.

Easter Egg photo from tillwe.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

13 Responses to “Gantt Box Chart Tutorial & Template – Download and Try today”

  1. Oli says:

    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.

  2. Dave says:

    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!

  3. Bob says:

    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

  4. Chandoo says:

    @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 🙂

  5. Mike H says:

    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

  6. Oli says:

    How embarrassing.

    I was obviously suffering from numerical dyslexia. I was one of those days.

  7. Chandoo says:

    @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

  8. 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.

  9. Lopi says:

    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

  10. [...] 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. [...]

  11. David says:

    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?

  12. Paul says:

    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?

Leave a Reply