• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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

This question is built off of previous questions - http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28413405.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
0
mdg1
Asked:
mdg1
  • 3
  • 3
1 Solution
 
Ken ButtersCommented:
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
0
 
Ken ButtersCommented:
One more thought... if you don't like the extra row of data called "Duration" (new row 13), then you can hide that row of data.

However, if you hide the row of data then the chart has to be modified slightly because by default, charts will not show hidden data.

to do this right click in the middle of the chart somewhere, then click on "select data".

In the lower left hand corner of the pop up window you'll see a button called "Hidden and Empty Cells".

Click on this button, the there is a checkbox in the bottom that you can check to "Show data in Hidden columns and rows".

If you don't mind the extra row of data, then you don't have to worry about this step.
0
 
mdg1Author Commented:
Wow- I think that works!  Let me play with it today and then will report back.  Thanks!
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Ken ButtersCommented:
Did this work for you?
0
 
mdg1Author Commented:
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.
0
 
mdg1Author Commented:
Fast and very helpful.  thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now