Dynamic Project Plan
Charts and Visualization Uncategorized VBA

Dynamic Project Planner (Gantt Chart) in Excel

Here we have created a beautiful and dynamic Project Plan (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type of status has been given Pending, Completed and In-Progress. We have used VBA to change the View daily to weekly and visa-versa. This is password protect worksheet. The password is “1234” Below is the Weekly View- [caption id="attachment_4053" align="aligncenter" width="1183"]
Change % in Pivot Table

Change% in Pivot Table

In this article you will learn how to show Change% in a pivot table. For example, you have month wise sales and revenue in your pivot and you have to show the change% in sales and revenue in compare of previous month. We will show the change% as given in below image. [caption id="attachment_3677" align="aligncenter" width="538"] Change% in Pivot Table[/caption] Steps show the change% in a pivot table- Lets say