{"id":2134,"date":"2021-02-16T17:54:16","date_gmt":"2021-02-16T08:54:16","guid":{"rendered":"https:\/\/blog.sphinfo.com\/?p=2134"},"modified":"2023-05-08T17:22:27","modified_gmt":"2023-05-08T08:22:27","slug":"gantt-chart-in-excel","status":"publish","type":"post","link":"https:\/\/blog.ifiedinc.com\/index.php\/2021\/02\/16\/gantt-chart-in-excel\/","title":{"rendered":"\uc5d1\uc140\ub85c \uac04\ud2b8 \ucc28\ud2b8 \ub9cc\ub4dc\ub294 \ubc29\ubc95"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

\uac04\ud2b8 \ucc28\ud2b8\ub294 \ud504\ub85c\uc81d\ud2b8 \ub9e4\ub2c8\uc800\uc5d0\uac8c \uc5c6\uc5b4\uc11c\ub294 \uc548 \ub420 \ub3c4\uad6c\ub77c\uace0 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uac04\ud2b8 \ucc28\ud2b8\ub294 \ub204\uac00 \ubb34\uc2a8 \uc77c\uc744 \ud558\uace0 \uc788\ub294\uc9c0, \uc5b8\uc81c \uc791\uc5c5\uc774 \uc644\ub8cc\ub418\ub294\uc9c0, \uc77c\uc774 \uacb9\uce58\uac70\ub098 \uc9c0\uc5f0\ub418\uace0 \uc788\ub294 \ubd80\ubd84\uc740 \uc5b4\ub514\uc778\uc9c0 \ub4f1\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4. <\/p>\n\n\n\n

\uae30\ubcf8\uc801\uc73c\ub85c \uac04\ud2b8 \ucc28\ud2b8\ub294 \ud654\ub824\ud55c \ub9c9\ub300 \ucc28\ud2b8\ub77c\uace0 \ubcf4\uc2dc\uba74 \ub418\ub294\ub370, \ud300\uc758 \uc791\uc5c5 \uc0c1\ud0dc\ub97c \uc544\uc8fc \uc27d\uac8c \ubcfc \uc218 \uc788\uc8e0. <\/p>\n\n\n\n

\uadf8\ub807\uc9c0\ub9cc \uc801\uc808\ud55c \ud234 \uc5c6\uc774 \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub294 \uac83\uc740 \uc880 \uadc0\ucc2e\uc740 \uc77c\uc774 \ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

\uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub294 \uac00\uc7a5 \uc88b\uc740 \ubc29\ubc95\uc740 \uba3c\ub370\uc774\ub2f7\ucef4 \uac19\uc740 \uc6cc\ud06cOS\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub807\uc9c0\ub9cc \uc624\ud504\ub77c\uc778 \uc0c1\ud0dc\uc774\uac70\ub098, \uc774\ub7f0 \uc6cc\ud06cOS\ub97c \ub3c4\uc785\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc774\ub77c\uba74, \uc5d1\uc140\ub85c\ub3c4 \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

\uc774\ubc88 \ud3ec\uc2a4\ud305\uc5d0\uc11c PC\ub97c \uc774\uc6a9\ud574\uc11c \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub294 \ubc95, \ub9e5\uc73c\ub85c \uac04\ud2b8 \ucc28\ud2b8 \ub9cc\ub4dc\ub294 \ubc95, \uadf8\ub9ac\uace0 \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub294 \uac00\uc7a5 \uc26c\uc6b4 \ubc29\ubc95\uc744 \uc18c\uac1c\ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

<\/div>\n\n\n\n

\uc5d1\uc140\ub85c \uc5b4\ub5bb\uac8c \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub098\uc694?<\/h2>\n\n\n\n
<\/div>\n\n\n\n

\uc194\uc9c1\ud788 \ub9d0\ud558\uba74\u2026\uc5d1\uc140\ub85c \uc644\uc804\ud55c \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4e4 \uc218\ub294 \uc5c6\uc5b4\uc694. \ub300\uc2e0 \uac04\ud2b8 \ucc28\ud2b8\ucc98\ub7fc \ubcf4\uc774\ub294 \uc911\ucca9 \ub9c9\ub300\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

\uc774 \uacfc\uc815\uc740 \uc2dc\uac04\uc774 \uc544\uc8fc \uc624\ub798 \uac78\ub9ac\uae30 \ub54c\ubb38\uc5d0, PC\uc640 Mac \uc0ac\uc6a9\uc790\ub4e4\uc744 \uc704\ud574 \uc694\uc57d\ub41c \ubc84\uc804\uc744 \uc124\uba85\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

<\/div>\n\n\n\n

PC\uc5d0\uc11c \uc5d1\uc140\ub85c \uac04\ud2b8 \ucc28\ud2b8 \ub9cc\ub4dc\ub294 \ubc29\ubc95<\/h3>\n\n\n\n
<\/div>\n\n\n\n

1.\ud504\ub85c\uc81d\ud2b8 \uc77c\uc815\uc5d0 \ub9de\uac8c \uc5d1\uc140 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\uc138\uc694<\/strong><\/p>\n\n\n\n

\ud504\ub85c\uc81d\ud2b8\ub97c \ud0dc\uc2a4\ud06c \ubcc4\ub85c \ucabc\uac2d\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ub098\uc11c \ud0dc\uc2a4\ud06c\ub97c \uceec\ub7fc\uc73c\ub85c \ub9cc\ub4dc\uc138\uc694. \uc2dc\uc791\uc77c, \uc885\ub8cc\uc77c, \ud0dc\uc2a4\ud06c \uae30\uac04 \ub4f1\uc744 \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4<\/p>\n\n\n\n

2. \uc5d1\uc140 \ud14c\uc774\ube14\uc744 \uc911\ucca9 \ub9c9\ub300\ub85c \ubcc0\ud658\ud558\uc138\uc694 <\/strong><\/p>\n\n\n\n

\ube48 \uc140\uc744 \uc120\ud0dd\ud558\uace0, \u201cInsert(\uc0bd\uc785)\u201d \ud0ed\uc744 \ud074\ub9ad\ud558\uc138\uc694. \ucc28\ud2b8 \uc139\uc158\uc5d0\uc11c \u201cStacked Bar(\uc911\ucca9 \ub9c9\ub300)\u201d\ub97c \uc120\ud0dd\ud558\uc138\uc694. \u201c100% Stacked Bar(100% \uc911\ucca9 \ub9c9\ub300)\u201d\ub97c \ud074\ub9ad\ud558\uc2dc\uba74 \uc548\ub429\ub2c8\ub2e4! \uadf8\ub7ec\uba74 \uac04\ud2b8 \ucc28\ud2b8\uac00 \uc774\uc0c1\ud558\uac8c \ubcf4\uc77c \uc218 \uc788\uc5b4\uc694. <\/p>\n\n\n\n

3. \uc911\ucca9 \ub9c9\ub300 \ucc28\ud2b8 \ud3ec\ub9f7\uc744 \ub9cc\ub4dc\uc138\uc694 <\/strong><\/p>\n\n\n\n

\ub2e4\uc74c\uc73c\ub85c \ud0dc\uc2a4\ud06c \uc21c\uc11c\ub97c \ubc18\ub300\ub85c \ud558\uc5ec \uc8fc \uacf5\uc815\uc774 \ud0dc\uc2a4\ud06c \uc22b\uc790 0\uc5d0\uc11c\ubd80\ud130 \uc2dc\uc791\ud558\uac8c \ud574\uc57c \ud569\ub2c8\ub2e4. \uac04\ud2b8 \ucc28\ud2b8\uc758 \uc218\uc9c1 \uc561\uc138\uc2a4\uc5d0 \ub530\ub77c \ubaa8\ub4e0 \ud0dc\uc2a4\ud06c \ubaa9\ub85d\uc744 \uc120\ud0dd\ud558\uace0 \u201cBar Chart(\ub9c9\ub300 \ucc28\ud2b8)\u201d \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud55c \ub2e4\uc74c \u201cFormat axis(\ucd95 \ud3ec\ub9f7)\u201d\uc744 \uc120\ud0dd\ud558\uc138\uc694. \uadf8\ub7ec\uba74 \u201cCategories in reverse order(\uce74\ud14c\uace0\ub9ac \uc5ed\uc21c)\u201d\uc744 \uc120\ud0dd\ud558\ub294 \uccb4\ud06c\ubc15\uc2a4\uac00 \ub739\ub2c8\ub2e4. \uadf8\uac78 \ud074\ub9ad\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n\n

\ub2e4 \uc644\ub8cc\ud558\uace0 \ub098\uba74 \uc544\ub798\uc640 \uac19\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Mac\uc5d0\uc11c \uac04\ud2b8\ucc28\ud2b8 \ub9cc\ub4dc\ub294 \ubc95<\/h3>\n\n\n\n

Mac\uc5d0\uc11c \uac04\ud2b8\ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub294 \uac83\uc740 PC\uc5d0\uc11c\ubcf4\ub2e8 \uc870\uae08 \ub354 \uc27d\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc544\ub798 \uc138 \ub2e8\uacc4\ub9cc \ub530\ub77c\ud558\uc138\uc694:<\/p>\n\n\n\n

1.\uc5d1\uc140 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uc138\uc694<\/strong><\/p>\n\n\n\n

\ud0dc\uc2a4\ud06c \ubaa9\ub85d\uc744 \uc791\uc131\ud558\uace0 \uc774\ub97c \uc5d1\uc140 \ud14c\uc774\ube14\ub85c \ub9cc\ub4dc\uc138\uc694. <\/p>\n\n\n\n

2. \uc5d1\uc140 \ud14c\uc774\ube14\uc744 \uc911\ucca9 \ub9c9\ub300\ub85c \ubcc0\ud658\ud558\uc138\uc694 <\/strong><\/p>\n\n\n\n

\u201cInsert(\uc0bd\uc785)\u201d, \u201cInsert Bar Chart(\ub9c9\ub300 \ucc28\ud2b8 \uc0bd\uc785)\u201d, \uadf8\ub9ac\uace0 \u201cStacked Bar chart(\uc911\ucca9 \ub9c9\ub300 \ucc28\ud2b8)\u201d\ub97c \ud074\ub9ad\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

3. \uc5d1\uc140 \uac04\ud2b8 \ucc28\ud2b8 \ud3ec\ub9f7\uc744 \ub9cc\ub4dc\uc138\uc694<\/strong><\/p>\n\n\n\n

\ub370\uc774\ud130 \uc2dc\ub9ac\uc988\ub97c \ud074\ub9ad\ud558\uace0 \u201cFormat(\ud615\uc2dd)\u201d \ud0ed\uc73c\ub85c \uc774\ub3d9\ud55c \ub2e4\uc74c \u201cShape Fill(\ubaa8\uc591 \ucc44\uc6b0\uae30)\u201d \ubc0f \u201cNo Fill(\ucc44\uc6b0\uae30 \uc5c6\uc74c)\u201d\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. \uac04\ud2b8 \ucc28\ud2b8\ub97c \ud0dc\uc2a4\ud06c\uc758 \uc5ed\uc21c\uc73c\ub85c \uac00\uc838\uc624\ub824\uba74 (\uadf8\ub798\uc57c \uccab \ubc88\uc9f8 \ud0dc\uc2a4\ud06c\uac00 \uc81c\uc77c \uba3c\uc800 \uc624\uac8c \ub429\ub2c8\ub2e4) \ucee8\ud2b8\ub864 \ud0a4\ub97c \ub204\ub978 \uc0c1\ud0dc\uc5d0\uc11c \uc218\uc9c1 \ucd95\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. \uadf8\ub7f0 \ub2e4\uc74c \u201cFormat Axis(\ud3ec\ub9f7 \ucd95)\u201d\uc744 \ud074\ub9ad\ud558\uc5ec \u201cAxis Position(\ucd95 \uc704\uce58)\u201d \uc139\uc158\uc5d0\uc11c \u201cCategories in reverse order(\uce74\ud14c\uace0\ub9ac \uc5ed\uc21c)\u201d\uc744 \uc120\ud0dd\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n

\uae30\ubcf8 \uc791\uc5c5\uc740 \uc774\ub807\uc2b5\ub2c8\ub2e4. \uae30\ubcf8 \uc791\uc5c5\uc744 \ub05d\ub0b4\uace0 \ub098\uba74 \uceec\ub7ec \ucf54\ub529\uac19\uc740 \uc57d\uac04\uc758 \ucee4\uc2a4\ud130\ub9c8\uc774\uc9d5\uc744 \ucd94\uac00\ud558\uc5ec \uac04\ud2b8 \ucc28\ud2b8\ub97c \ud15c\ud50c\ub9bf\uc73c\ub85c \uc800\uc7a5\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

\uc5d1\uc140\uc5d0 \uac04\ud2b8 \ucc28\ud2b8 \ud15c\ud50c\ub9bf\uc774 \uc788\ub098\uc694?<\/h2>\n\n\n\n

\ub124. \uc544\ub2c8\uc694. \uc544\ub9c8\ub3c4\uc694?!<\/p>\n\n\n\n

PC\ub97c \uc0ac\uc6a9\ud558\uc2e0\ub2e4\uba74 \uc5d1\uc140\uc5d0 \uac04\ud2b8 \ucc28\ud2b8 \ud15c\ud50c\ub9bf\uc774 \uc788\uace0, Mac\uc744 \uc0ac\uc6a9\ud558\uc2e0\ub2e4\uba74 \uc9c1\uc811 \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\ub9c8\uc774\ud06c\ub85c\uc18c\ud504\ud2b8 \uc6f9\uc0ac\uc774\ud2b8\uc5d0 \uac00\uc2dc\uba74 \uc5d1\uc140 \uac04\ud2b8 \ud504\ub85c\uc81d\ud2b8 \ud50c\ub798\ub108 \ud15c\ud50c\ub9bf\uc744 \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

PC \uc0ac\uc6a9\uc790\uac00 \uc544\ub2c8\uc2dc\ub77c\uba74 (\ub610\ub294 \uac04\ud2b8 \ucc28\ud2b8\ub97c \uc9c1\uc811 \ub9cc\ub4e4\uace0 \uc2f6\ub2e4\uba74) \uac00\uc7a5 \uc88b\uc740 \ubc29\ubc95\uc740 monday.com<\/a>\uacfc \uac19\uc740 Work OS\ub97c \ub9cc\ub4dc\ub294 \uac83\uc774\uaca0\uc9c0\uc694. \uc544\ub798\uc5d0\uc11c \ubc29\ubc95\uc744 \uc18c\uac1c\ud574\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

<\/div>\n\n\n\n

\uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4dc\ub294 \uac00\uc7a5 \uc26c\uc6b4 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc778\uac00\uc694?<\/h2>\n\n\n\n

\ubb3c\ub860 \uc2dc\uac04\uc774 \ub9ce\ub2e4\uba74 \uc5d1\uc140\ub85c \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\ub3c4 \ub429\ub2c8\ub2e4. \uadf8\uce58\ub9cc \uc2dc\uac04\uc740 \uae08\uc774\uc796\uc544\uc694? \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0 \uc6cc\ud06cOS\ub97c \ud1b5\ud574 \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n

\uba3c\ub370\uc774\ub2f7\ucef4\uc73c\ub85c \uac04\ud2b8 \ucc28\ud2b8\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574\uc11c\ub294 \uc544\ub798\uc758 \uc138 \ub2e8\uacc4\ub9cc \ub530\ub77c\ud558\uba74 \ub429\ub2c8\ub2e4:<\/p>\n\n\n\n

  1. \ubcf4\ub4dc \ub9cc\ub4e4\uace0 \ud0dc\uc2a4\ud06c \ucd94\uac00\ud558\uae30 <\/li>
  2. \ubcf4\ub4dc\uc5d0 \u201c\ud0dc\uc2a4\ud06c \ud0c0\uc784\ub77c\uc778\u201d \uceec\ub7fc \ucd94\uac00\ud558\uae30<\/li>
  3. \u201c\ubcf4\uae30\u201d\ub85c \uac00\uc11c \ud0c0\uc784\ub77c\uc778\uc774\ub098 \uac04\ud2b8 \ubcf4\uae30 \uc120\ud0dd\ud558\uae30<\/li><\/ol>\n\n\n\n

    \uc774\uac8c \ub05d\uc785\ub2c8\ub2e4!<\/p>\n\n\n\n

    \uc544\ubb34\ub9ac \uc624\ub798 \uac78\ub824\ub3c4 \uba87 \ubd84\uc774\uba74 \uc644\uc131 \ub420\uac70\uc608\uc694. \ubcf5\uc7a1\ud55c \ud615\uc2dd \uc124\uc815\uc774\ub098 OTT \ub0b4\ube44\uac8c\uc774\uc158 \uc774\ub7f0 \uac83\ub4e4\ub3c4 \ud544\uc694 \uc5c6\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ubb34\uc5c7\ubcf4\ub2e4\ub3c4, \ud6e8\uc52c \uc608\uc058\uc796\uc544\uc694?<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    \uac04\ud2b8 \ucc28\ud2b8\ub97c \uc27d\uac8c \ub9cc\ub4e4 \uc900\ube44\uac00 \ub418\uc168\ub098\uc694? \uadf8\ub807\ub2e4\uba74 \uba3c\ub370\uc774\ub2f7\ucef4\uc744 \ubb34\ub8cc\ub85c \uccb4\ud5d8\ud574\ubcf4\uc138\uc694. <\/p>\n\n\n\n

    <\/div>\n\n\n\n
    \"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

    \uac04\ud2b8 \ucc28\ud2b8\ub294 \ud504\ub85c\uc81d\ud2b8 \ub9e4\ub2c8\uc800\uc5d0\uac8c \uc5c6\uc5b4\uc11c\ub294 \uc548 \ub420 \ub3c4\uad6c\ub77c\uace0 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac04\ud2b8 \ucc28\ud2b8\ub294 \ub204\uac00 \ubb34\uc2a8 \uc77c\uc744 \ud558\uace0 \uc788\ub294\uc9c0, […]<\/p>\n","protected":false},"author":1,"featured_media":2141,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[179,174,15,180,177],"tags":[],"class_list":["post-2134","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-function","category-guide","category-pm","category-task","category-pm2"],"_links":{"self":[{"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/posts\/2134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/comments?post=2134"}],"version-history":[{"count":12,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/posts\/2134\/revisions"}],"predecessor-version":[{"id":2151,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/posts\/2134\/revisions\/2151"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/media\/2141"}],"wp:attachment":[{"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/media?parent=2134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/categories?post=2134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ifiedinc.com\/index.php\/wp-json\/wp\/v2\/tags?post=2134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}