how to create a stacked bar chart in excel on mac for a gantt chart

Create A Stacked Bar Chart In Excel On For A Gantt Chart Free Template Online
Create A Stacked Bar Chart In Excel On For A Gantt Chart How To By Hasaan
Create A Stacked Bar Chart In Excel On For A Gantt Chart Professional Business Subjects

He also found ACCA LIVE which is Pakistans first portal to provide online classes and distance learning solutions to FIAACCA students.

Create A Stacked Bar Chart In Excel On For A Gantt Chart How To By Hasaan

PakAccountants.com Home ACCA FIA DIPIFR CIMA ICAP Excel Excel Basics Excel Formulas Excel Charts Excel Pivot Tables Standards International Accounting Standards (IASs) International Financial Reporting Standards (IFRSs) International Standards on Auditing (ISAs) Online Courses Financial Accounting Cost and Management Accounting English (UK) Company Law English (UK) Contract Law Business Analysis Dictionary Shop Buy Excel Templates and Resources Add a vertical line to Gantt Chart or Stacked Bar Chart in Excel How To By Hasaan Fazal Facebook Twitter WhatsApp Pinterest In last tutorial on gantt chart in Excel for project managers we learnt the simplest and fastest way to chart project activitiestasks.

Today we are learning how to add a vertical line on the gantt chart representing current or any other specific date for better understanding of the gantt chart user.

For this tutorial you need a gantt chart already done that I have discussed in detail here so if you do not have the gantt chart ready, get it done and then continue with this tutorial.

This is what we will be achieving by the end of this tutorial: Add a vertical line to Gantt Chart Excel Stacked Bar Chart Step by Step For any straight line you need at least two points on the chart and for each point you need two coordinates where each is representing its reference location along X and Y axis.

Gantt chart is horizontal stacked bar chart running from left to right, therefore we would like to have our time-line running perpendicular to these bars top to bottom.

Also, the dates are charted along the X-axis so our time-line will be perpendicular to X-axis with x-coordinate to be either current date (or specific date if we choose to show specific date).

If it doesnt make sense yet, dont worry and lets move on Step 1: In two empty cells input X and Y each.

Under X put the current date either manually or use TODAY() function.

You can use any other specific date of your own choice as well.

I will enter the date manually so that gantt chart with vertical line template file remains easy to understand for future readers as well otherwise to draw current date on gantt chart function approach is better.

Step 3: Select chart (dont forget to select chart first) by simply clicking anywhere empty in it and go to home tab click drop down arrow under paste button click paste special.

A dialogue box will open, leave the default values (i.e.

OK.

You will notice a small bit added to the chart in front of second task as new series.

Step 4: Right click on newly added series and click change series chart type.

Click secondary axis check box and select scatter with straight lines.

You will instantly see a vertical straight line added to the gantt chart.

We are almost done.

Step 5: On the right side you will see newly inserted secondary vertical axis, double click on it to invoke format axis options.

From there, in maximum input box, input 1 and press enter key.

But if you like to format the line as well then continue with one last step.

Step 6: Double click on the vertical line to access format options.

And finally here you have the gantt chart with vertical line working amazingly showing change in date immediately when date is changed Remember you will have to change the date in both cells.

In my case I will use the formula I5 in cell I6 to fetch the date so that I will have to change the date only in one cell.

Create A Stacked Bar Chart In Excel On For A Gantt Chart Professional Business Subjects

Create A Stacked Bar Chart In Excel On For A Gantt Chart Free Template Online

So there you have it A fully functional gantt chart with planned and completion status indicated and also the currentspecific date drawn right on the gantt chart all done in Excel Liked Gantt Chart with Vertical Date Line Pin it Facebook Twitter WhatsApp Pinterest Previous article Gantt Chart in Excel How To Free Template Online Gantt Chart Creator Next article Vertical Actual vs Target Charts in Excel Top to Bottom Variance Analysis using Bar Charts Hasaan Fazal Teaching professional business subjects to the students of FIA, ACCA, CIMA, CA etc.

How To Create A Stacked Bar Chart In Excel On Mac For A Gantt Chart