Pin Me

Creating Quattro Pro Gantt Charts

written by: Michele McDonough • edited by: Michele McDonough • updated: 5/19/2011

Quattro Pro X4 has a nice built-in utility that allows you to create Gantt charts, but that tool can be a little tricky to use if you don't set up your initial data just right. In this tutorial, we'll give step-by-step instructions for using the Quattro Pro Gantt chart tool.

  • slide 1 of 20

    Constructing Gantt Charts in Quattro Pro

    Most dedicated project management software applications have some sort of Gantt chart utility that basically lets you click a few buttons and construct a Gantt chart with little to no fuss. However, you can also use almost any spreadsheet program to create one of these scheduling tools as well, if you're willing to put in a bit of extra effort. Depending on the program, though, this may take some work as demonstrated in the tutorial on how to create a Gantt chart in Excel.

    Quattro Pro users should have an easier time with this task, since Quattro Pro includes a built-in Gantt chart generator. Yet, this tool still has a few quirks, and it may take a little practice to get used to it. To make things a little easier, this tutorial will walk through the steps needed to create a Gantt chart in Quattro Pro X4.

  • slide 2 of 20


    Step 1: To start out, enter the data for your Gantt chart in Quattro Pro. You should have three columns – Task Name, Start Date, and Duration of Task. If you want to include additional columns, that's fine, but remember to only select these three columns when creating your chart. The screenshot below shows sample project data that we'll be using during this tutorial. (Click any image for a larger view.)

    Sample Gantt Chart Data 

  • slide 3 of 20

    Step 2: Select the three columns containing the Task Name, Start Date, and Duration information.

    Select the Information 

  • slide 4 of 20

    Step 3: From the Insert menu on Quattro Pro's main toolbar, select Chart and then Use Chart Expert.

    Select Chart Expert 

  • slide 5 of 20

    Step 4: In the first window of the Chart Expert wizard, don't worry about any of the options except the one dealing with chart placement. Under the words Place chart in, choose whether you want to include the chart in the current sheet or place it in a new chart window. For this tutorial, we'll keep the chart in the current sheet.

    Decide Chart Placement 

  • slide 6 of 20

    Click Next to continue.

    Step 5: In the second screen of the Chart Expert wizard, select Gantt.

    Select Gantt Chart 

  • slide 7 of 20

    Click Next to continue.

    Step 6: The third window allows you to enter titles and labels for the chart itself as well as the chart axes. Entering information here is completely optional.

    Enter Titles and Labels 

  • slide 8 of 20

    We'll just leave those blank for now and click Next.

    Step 7: The fourth and final window of the Chart Expert wizard gives you the opportunity to pick a color scheme for the chart. This is for purely aesthetic purposes. For now, we'll just accept the default theme.

    Pick Color Scheme 

  • slide 9 of 20

    Click Finish to continue.

    Step 8: Unlike with Excel, charts do not immediately appear when they have been created. You must first click anywhere on the spreadsheet, hold down the mouse button, and drag the mouse to define your chart area.

    Insert the Chart 

  • slide 10 of 20

    When you release the mouse button, the Gantt chart will appear on your sheet.

    Initial Gantt Chart 

  • slide 11 of 20

    Unfortunately, we're not quite done yet. Note that the dates are showing up as numbers – that's not very helpful. Also, we really don't need the legend that's showing up on the side of the chart. So, we'll go through a couple more steps to fix these problems.

  • slide 12 of 20

    Modifying Chart Defaults to a Quattro Pro Gantt Chart

    Step 9: First, we'll get rid of the legend. Click on the legend to select it. Once the legend is selected within the chart, right-click and choose Legend Properties.

  • slide 13 of 20
  • slide 14 of 20

    When the Legend Properties window appears, remove the check mark from the box next to Display Legend by clicking on it.

    Uncheck Display Legend 

  • slide 15 of 20

    Click OK and you will exit the Legend Properties window to return to the Quattro Pro spreadsheet with the Gantt chart. The legend will no longer be present, as shown in the image below.

    Gantt Chart Without Legend 

  • slide 16 of 20

    Step 10: Finally, we want to modify the data so that the dates are actually in date format. To do this, first click anywhere on the date axis labels to select that information. Then right-click over that same area and choose Y-Axis Properties. (Note: Despite the fact that this axis really looks like the X-axis due to the layout of the graph, Quattro Pro is calling this axis the Y-axis since the chart is turned on its side. If this bothers you, trust me – you're not alone.)

    Change Y-Axis Properties 

  • slide 17 of 20

    When the Axis Properties window appears on your screen, select the tab labeled Numeric Format. From the Category list, select Date. Then use the drop down box to choose the exact date format that you want to use. As an example, we'll pick the 03/04/98 format.

    Change to Date Format 

  • slide 18 of 20

    Additionally, if you want to change the number of dates shown on the chart, go to the Scale tab and enter a new number for Increment. In this example, 1 denotes 1 day, so we can make a change to use an increment of 91. This basically represents three months. So, on the Gantt chart representation, the intervals will be broken up into three months and the corresponding start dates for those intervals will be shown.

    Change the Scale Increment  The value you choose here is dependent on the length of your project and how much detail you want to depict.

  • slide 19 of 20

    Click OK when done to exit the Axis Properties window. You'll be returned to the Quattro Pro spreadsheet with the changes applied to your Gantt chart.

    Final Gantt Chart 

  • slide 20 of 20

    From here, you can dress up the appearance of your chart using the same methods you would for any other chart in Quattro Pro.