How to Make a Gantt Chart Using Microsoft

104 5
    • 1


      Open a new Excel worksheet. Enter column headings into Row 1, such as "Start Date," "Amount Completed" and "Amount Remaining." Enter your data into the columns for each heading.

    • 2


      Select the cells that contain data. If you are using Excel 2003 or earlier, click the "Chart Wizard" button on the "Standard" toolbar. In Excel 2007, go to the "Chart" section on the "Insert" tab. Select "Bar" as the chart type, and then select "Stacked Bar" as the subtype. Click "Finish."

    • 3


      Double click the first color in the chart bars to open the "Format Data Series" dialog box. Go to the "Patterns" tab. Select "None" for both "Area" and "Border," and then click "OK."

    • 4


      Double click the "Category Axis," go to the "Scale" tab and select "Categories in Reverse Order." Go to the "Font" tab and change the font size to "8." Click "OK."

    • 5


      Double click the "Value Axis" and go to the "Alignment" tab. Enter "45" in the "Degrees" box. Go to the "Font" tab and select "Bold" under "Font Style" and "8" for the font size. Click "OK."

Source...
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time

Leave A Reply

Your email address will not be published.