![]() ![]() ![]() To rectify this, right click on the vertical axis and choose Format Axis… Step 4: Reverse the Order of the TasksĪs you can see, the tasks are in the reverse order. Remember that number.īack at the bar chart, right click on the X axis, and choose Format Axis…Įnter the number you found into the Minimum box, and play with the Minimum and Maximum until you find the right range. Under Number > General, you will see the numerical number for that date. Select the earliest date in the spreadsheet, right-click, and choose Format Cells. This makes fixing the X axis a little bit more difficult, but here’s the procedure. Unfortunately, MS Excel uses numbered dates which go sequentially and start at zero on January 1, 1900. The size of the X axis goes all the way from Januuntil today! You cannot see the duration bars in between the blue and grey bars because they are extremely small. The chart that is produced will look like this: Step 3: Adjust the x-axis Enter the data like this: Step 2: Create the Bar Chartįrom the menu, choose Insert > Column or Bar Chart > 2D Bar > Stacked Bar. ![]() Make sure you have the following four columnsĪlthough the third column can be calculated from the first two, all three need to be present. The first step is to enter your tasks in table form in Excel. A simple one will take about 15 minutes with only a basic knowledge of Excel, and I’m going to show you how. Believe it or not, gantt charts can be created relatively painlessly in MS Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |