![]() Steps 3 and 4 of the wizard can be skipped, though, on Step 3 you may want to hide the Legend. Select the “Bar” Chart type, and the Stacked Bar sub-type, then click Next.Ĭlick the Series tab, and Add another Series.įor Name, select the cell for the Duration Column Header (cell D1)įor Values, select the cells for for the Duration data (cells D2:D5) Select just the Activity and Start Date data (eg. You’ll need to set the Cell Format back to General, or column D will look like a date. Note: the formula in column D2 is =C2-B2. It should work the same for other versions.Ĭreate a worksheet similar to the above table. ![]() The following example was created for Excel 2003. I recently discovered how quick it is to create a simple Gantt chart in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |