asked on

Excel - Find a way to illustrate the months during which we are deployed on various projects

This question is built off of previous questions - https://www.experts-exchange.com/questions/28413405/Revenue-and-cost-calculations-based-on-timing-of-rollout-criteria.html

Look at the attached example on the tab marked Timeline to get an example of what I want to automate

I can manually put the name of the companies in Column 1 on the new tab but want it to pull the data from the tab marked example.

Let me know if you need more of an explanation.
Monthly-Model-Example-with-timel.xlsx

Ken Butters

For this I'd like to recommend a slightly different approach.

If you don't like this solution, the one you suggested is possible with VBA code, so feel free to reject this one. Just let me know.

However that being said, what you are really creating is a bar chart.

I've added a bar chart to the example tab, and it will automatically update itself when you update your criteria.

In order to make this bar chart appear in the format you are looking for, I added a helper row of data... Called "Duration" (see new Row 13 on the Example Tab).

Duration is computed by subtracting the starting month from the ending month.

Using the bar chart, it is easy to drag to position it or resize it to anywhere you want to see it on your worksheet.

Here is step by step on procedure to add this style of chart based on your data:
http://www.smartsheet.com/blog/gantt-chart-excel
Monthly-Model-Example-with-timel.xlsx

ASKER CERTIFIED SOLUTION

Ken Butters

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mdg1

ASKER

Wow- I think that works! Let me play with it today and then will report back. Thanks!

Ken Butters

Did this work for you?

mdg1

ASKER

it worked. A bit cumbersome to get it set up but now that it is, I think we're good. Will have some more follow-up projects. I'll post them here to let you know what they are. Thanks! It's looking really great.

mdg1

ASKER

Fast and very helpful. thanks.