24 Interessant Arbeitsplan Vorlage Excel Beispiel


Work alone or create a workspace for your team. Ability to drag and expand the tasks, assign people and costs. If you wish to learn how to make a timeline in Excel, please see our timeline tutorial here.

Plan your project and manage tasks with the help of the online Gantt chart


This site uses technical cookies and allows the sending of 'third-party' cookies. By continuing to browse, you accept the use of cookies.

For more information or to refuse consent to some or all cookies, see the dedicated section. Why us Pricing Sign in Sign up. Online project management solution based on Gantt charts Keep your planning simple, team members - engaged, clients - in the loop! No credit cards required. Achieve your best results in project management! Try GanttPRO for free online to see the difference: Plan your project and manage tasks with the help of the online Gantt chart Interactive online Gantt chart software for planning and controlling multiple projects at once.

As many different project plans online as you need, structured Use different workspaces for personal tasks and team projects. Automatic online project scheduling and drag and drop simplicity You and your team need 3 minutes to become advanced users of GanttPRO.

Manage team and track progress with the online Gantt chart maker Our project planning software has basic Gantt charts features as well as features of the team management software. Manage resources and estimate project costs Our Gantt chart software allows you to add another dimension to your projects - resource planning.

From a simple Gantt chart to complex project management. I really enjoy how easy and clean this application with very intuitive UI. Also big fun of different customizations you can apply for different projects and teams to reflect your needs. And when i did start initially preconfigured templates they had saved me a lot of time.

Outstanding tool which makes the complex very simple. Elegant and easy to use tool which makes managing a complex project visually appealing and easier to manage tasks and interdependencies. Chat support and email support are very responsive. After searching around I finally found software to create Gantt charts which looks like I want. Easy to create and share charts which are functional and easy to read and understand for collaborators.

Perfect tool for to have overview of the projects and related tasks. Lot of possibilities to add and attach useful information. Andrejs Balodis Owner Klinta Ltd. I love being able to visualize my projects and assign different colors to the different elements. Entering the tasks forces me to thinking through the steps of each element. The interface is easy to learn and to work with.

Time management functions save time. The best software for the planning purposes in a dynamic way. Helps for the effective planning and decision making in an organization. Ability to drag and expand the tasks, assign people and costs. Easy to handle multiple projects and to delay tasks that are linked. Learn how to plan projects easily using Gantt charts. We are happy to deliver the best value to people who choose us.

Support Help center Terms of service Privacy policy Security. Web design Product launch plan Retail Learning roadmap. Click on the Add button to bring up Excel's Edit Series window and here you will begin adding Task data to your Gantt chart. First we need to name the data Series we will be entering.

Click and place your cursor in the empty field under the title Series name , then click on the column header that reads Start Date in your table. Staying in the Edit Series window move down to Series value. This is where you will enter your Task start dates. It is easy to do. To the right of the Series values field you will see an icon which looks like a spreadsheet with a red arrow on it. Click on it the one by Series values and Excel will open a smaller Edit Series window. Now simply click the first start date in your task table and drag your mouse down to the last start date.

This highlights all of the start dates for your tasks and inputs them into your Gantt chart. Make sure you have not mistakenly highlighted the header or any extra cells. When finished, click on the small spreadsheet icon again the one with the red arrow which will return you to the previous window called Edit Series. Your Gantt should now look like this:. Here we will add the duration data to your Gantt chart.

In the Edit Series window, click in the empty field under the title Series Name , then click in your Task table again, on the column header that reads Duration. Staying in the Edit Series window move down to Series value and click on spreadsheet icon with a red arrow on it again.

Select your Duration data by clicking on the first Duration in your project table and drag your mouse down to the last duration so all durations are now highlighted. To exit, once again click on the small spreadsheet icon with the red arrow to which will return you to the previous window. Click OK again to build your Gantt chart which should now look something like this:. Right-click on one of the blue bars in the Gantt chart, then click on Select Data again to bring up the Select Data Source window.

Select the Edit button to bring up a smaller Axis Label windows. Again, click on the small spreadsheet icon. Be careful not to include the name of the column itself. When you are done, exit this window by clicking on the small spreadsheet icon again.

Your chart should now look something like this:. You have really built a Stacked bar chart. Now we need to format it so it looks like a Gantt chart. To do that, we must make the blue parts of each task bar transparent so only the orange parts will be visible. These will become the tasks of your Gantt chart. To select all of the tasks bars at once, click on the blue part of any bar in your Gantt chart, then right-click and select Format Data Series , which will bring up the Format Data Series window in Excel.

Don't close the Format Data Series task pane because we're going to use it in the next step. You probably also see that the tasks on your Gantt chart are listed in reverse order with the last task on top of the Gantt chart and the first Task listed at the bottom. This is easy to change in Excel. To do so click on the list of tasks along the vertical axis of your Gantt chart. This will select them all and it will also open the Format Axis task pane.

In the Format Axis task pane under the header Axis Options and the sub-header Axis Position put a check into the checkbox called Categories in reverse order. You will notice that Excel arranged your tasks into proper order, listing them from first to last on your Gantt chart.

You will also notice that Excel moved the date markers from beneath to the top of the Gantt chart. Now it is really starting to look more like a Gantt chart should. Removing some of the blank white space where the blue bars used to be will bring your tasks a little closer to the vertical axis of your Gantt chart.

To remove some of the blank white space in the chart, click on the dates above the task bars. One click should select all the dates, then right click and select Format Axis to bring up Excel's Axis Options window.

In the Axis Options window, under the header called Bounds, note the current number for Minimum Bounds.

It represents the left most boundary of your Gantt chart. Changing this number by making it larger will bring your tasks closer to the vertical axis of your Gantt chart.

In my case I changed the original number which was At any time you can hit the reset button to return the original settings. This gives you the opportunity to try a number of different settings until you find the one the makes your Gantt chart look best. In the same Axis Options window under the header Units, you can adjustment the spacing between each of the dates listed at the top of the horizontal Axis.

If you increase the unit number your Gantt chart will enlarge the space between each date, which will also lessen the number of dates your Gantt chart shows. Doing the opposite, reduces the space between each date and therefore crowds more dates onto your Gantt chart.

In my case I changed the original number from 20 to Under the Series Options header you will find the Gap Width control.