How to Create Excel Gantt charts and Timelines in Minutes !
Below are the top discussions from Reddit that mention this online Udemy course.
Project management is a wonderful art of managing different tasks and various task dependencies , material , people , funds and information.
Reddemy may receive an affiliate commission if you enroll in a paid course after using these buttons to visit Udemy. Thank you for using these buttons to support Reddemy.
Taught by
Amey Vidvans
Reddit Posts and Comments
0 posts • 2 mentions • top 1 shown below
1 points • IAmey
Hello ,
Please try following steps.
Step 1 - Insert Chart
- Select Start dates > Go to Insert tab > Under charts > Select 2D stacked bars.
step 2 - Add horizontal Axis labels.
- select chart > Right click and click on select data.
- select start series > Under horizontal Axis label > click on edit > Select Activity list.
Step 3 - Add duration series.
- on the left hand side click on add.
- select durations
- under horizontal Axis labels again select Activity list.
Step 4 - Format Vertical Axis.
- Select Axis > Right click > format Axis > Go to Axis option > check categories in reverse order.
Step 5 - Format Horizontal Axis.
- Select Horizontal Axis. > Right click > format Axis.
- Under Axis Option-
- Under bounds- this will define start and finish of your Timescale or Timeline.
- Under minimum Enter date less than your start date of first activity.
- Under maximum Enter date greater than finish of your last activity.
Step 6 - Hide start Series.
- select Start series bars.
- Go to format > No fill and no outline.
Please check if this helps. Please revert in case you need further assistance.
With warm regards.