Shulou(Shulou.com)06/01 Report--

This article is to share with you how to use the tool Gantt chart about time management. Xiaobian thinks it is quite practical, so share it with you to learn. I hope you can gain something after reading this article. Let's not say much. Let's take a look at it together with Xiaobian.

Today I want to share with you a tool for time management-Gantt Chart.

The idea behind this chart is very simple. You can create a Gantt chart by setting the project start time and duration, stacking bars, and hiding some of the data bars.

First of all, we need to prepare the original data and process the original data.

We see two data areas in the above graph, in fact, the same values, but the START data in the right graph changes the date format to the numerical format (all date and time data in excel are constructed with numerical values, starting from 1900).

Then insert a stacked bar chart with the data on the right.

Then reverse the bar chart data sequence, fill the left bar with transparent color, and adjust the bar spacing.

Finally, change the horizontal axis data display mode to date, and change the maximum value and minimum value to within the maximum value and minimum value range of the original data area (you can appropriately exceed the minimum value and maximum value by a little).

Change the density, font, color, and more of the gridlines.

Of course, you can also highlight a partial progress bar (double-click to select a data bar alone and change the fill color).

The above is how to use Gantt chart, a tool for time management. Xiaobian believes that some knowledge points may be seen or used in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.