The chart may look like the one given below. (in this example, we have considered “Units” as 5) The units of date can adjust the scale as you want to see in the chart.In the panel, change the “Minimum” number under the “Bounds” options to the number you have noted.Click on the dates on the top of the chart and right-click, select “Format Axis.”.Note the number in the window under the “Number tab” and “General” categories.Right-click on the date given for the first task in a table and select “Format Cells.”.Remove the white space at the beginning of the chart. Now, the project timeline Excel Gantt chart is almost completed. In the “Format Data Series” panel, select “No Fill” under the “Fill” section and “No line” under the “Border” section.Click on the blue bar to select and right-click “Format Data Series.”.We need to make a blue bar invisible to show only the orange bars, which indicate the duration. When the categories are reversed, we may see the chart below. In a “Format Axis” panel, under the “Axis Options” section, check the “Categories in reverse order” box. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |