- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
Blue Excel-Gantt Chart Plan Generation Tool Function Introduction
Resource planning is used to allocate tasks to various resources. Typically, you have several resources available for development, and tasks are assigned to those resources. This tool simplifies these tasks.
Like integrated planning, resource planning uses graphical task bars to describe tasks. All operations for the graphical taskbar are the same as for the integrated plan.
The integration plan is used to display the integration between different tasks. Usually tasks are represented in the form of graphical task bars. The advantage of the graphics task bar is that it is not limited by the start time and end time in Excel and can be drawn at any position. BlueExcel provides a series of convenient operation tools for the graphics task bar.
Integrated planning can be used in conjunction with task planning. In general, the advantage of integrated planning is that multiple tasks can be displayed graphically on the same line. The sequence of tasks can be displayed more clearly, and as many tasks as possible can be displayed within a smaller visual range.
Introduction to the features of Blue Excel-Gantt chart plan generation tool
[Create vertical connection]
Applies to cells and graphics. Select a cell and then press the [Ctrl] key to select another cell, and click the button to create a straight line with an arrow connecting the two cells.
The same graphic can also be selected, which can also generate straight lines connected to graphics. Convenient to express task bar dependencies or draw flow charts.
You can add detailed information to each graphic taskbar. The taskbar can display very limited information. This method is your responsibility
[Free Task Plan]-Free task plan template
You can start the Free Plan template from the Windows Start button, [Start]-[All Programs]-[Blue Excel]-[Free Plan].
Blue Excel-Gantt Chart Plan Generation Tool Installation Steps
1. Put Blue into the Huajun Software Park Download the Excel-Gantt chart plan generation tool, unzip it to the current folder, click the setup-blueexcel.exe application to enter the installation wizard interface, and then click next.
2. Select the path you want. Huajun editor recommends that users install it on the D drive. After selecting, click OK, and then click Next.
3. The installation of Blue Excel-Gantt chart plan generation tool is completed.
How to use Blue Excel-Gantt chart plan generation tool
Blue Excel Toolbar
[Blue Excel Super Tool]
[Blue Excel Tools]
[Blue floating common toolbar]
[Blue Plan Toolbar]
[Cell Task Bar] -Cell merge task bar
As shown below, the cell task bar is formed by merging cells. Cell task bars are automatically generated based on the input date and end date.
[Shape Task Bar]-Graphic task bar
The graphic taskbar is represented by a graphic as shown below. You can generate and perform corresponding mobile expansion and other operations through the floating plan toolbar.
Blue Excel-Gantt Chart Plan Generation Tool Shortcut Key
[Ctrl]+[Up Arrow] - Expand the selected graphics taskbar from the top of the graphics
[Ctrl]+[Down Arrow] - Compresses the selected graphics taskbar from the top of the graphics
[Alt]+[Up Arrow] - Compresses the selected graphics taskbar from the bottom of the graphics
[Alt]+[Down Arrow] - Expand the selected graphics taskbar from the bottom of the graphics
[Create a task bar by merging cells]
[Ctrl]+[Shift]+b - Generate a cell task bar in the selected cell
[Through graphics and creating task bars]
[Ctrl]+[Shift]+s - Generate a graphical taskbar in the selected cell
[F6] - Opens the Comments/Details dialog box
[F5] - Open the planning toolbar
[F7] - Opens the Quick Toolbar.
[F10] - Open the quick filter tool
[F11] - Open the macro tool box
[F12] - Open the command tool box
Blue Excel-Gantt Chart Plan Generation Tool Frequently Asked Questions
Question: The Blue Excel-Gantt chart plan generation tool can create the Gantt chart of my plan, but I don’t know how to track it?
Answer: The easiest way is to change the layout of the data source. Put the plan and actual in different rows.
ask: How to generate a Gantt chart in EXCEL?
Answer: 1. The Gantt chart that the questioner needs to draw needs to be generated in the office project, which is called project management;
2. In excel, it is impossible to meet the automatic generation function required by the subject, and it is also impossible to draw a Gantt chart;
3. The Gantt chart does not require a template. Use project to input project task information and a fully functional Gantt chart can be generated directly;
Comparison of similar software
Excel Universal Treasure BoxIt is the famous Microsoft Office software EXCEL (Microsoft Office for EXCEL) super large plug-in. It has built-in picture treasure box, financial treasure box, function treasure box, and QR code treasure box. It includes more than 280 menu functions and 200 gain utility functions, integrating 480 treasures into one, but the size is less than 30MB. After installing Universal Treasure Box, if you use Excel 2003, the [Universal Treasure Box] menu will be generated, including more than 280 menus; if you use Excel 2013 or 2016, the [Classic] and [Universal Treasure Box] functional areas will be generated.
Kingsoft pdf readerThe official download version is a great PDF reader. Kingsoft products have always been good to use. This Kingsoft PDF reader supports multiple browsing modes, adds new bookmarks, reading records and other functions. It is simple and easy to use. Huajun Software Park provides the official download of Kingsoft PDF Reader!
Blue Excel-Gantt Chart Plan Generation Tool Update Log
Supports formula input for task dates.
Keep the details dialog box open, support changing cell and shape selections, and the details change accordingly for easy browsing.
Details are resized and saved for easy browsing.
The detailed information includes the number of cells contained in the selected cell task bar and the graphic task bar. You can quickly count the number of weeks or days covered by the task bar.
You can enter prerequisites and details directly before and after the task bar.
Huajun editor recommends:
Blue The Excel-Gantt chart plan generation tool can also effectively allow you to expand the functions of Excel software, making it easier for you to count projects, manage projects, create charts, etc. more quickly. Also recommendedHanwang Attendance Management System,Aimo mind map,WPS Office,NTKO large file upload control,Kuai Dao Ke platform softwareDownload and use related software.
it works
it works
it works