Excel Country Gantt Chart (multi-image)

Objective

Must draw the picture, I looked for a very long time did not find a special Gantt chart better software, after the study of the final use of Excel to draw a Gantt chart, online this information but no YO!

Effect

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdtaxmde5mtazna==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center ">

Detailed steps

1 Create a form, as I wrote.

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdtaxmde5mtazna==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center ">

2 Generating a bar chart

3 Changing the number of references check effect

4 Reverse Task

5 Adjust to date type

6 Change the number of days to 100 days (you can adjust your own time)

7 Change the number again (first time wrong)

8 hiding the corresponding bar

9 Change to Wireless bar, green bar chart and blue do the same operation, after the effect 10

10 Preview of effects (red bars are planned days, Purple is actual running days)

11 Delete useless data

watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvdtaxmde5mtazna==/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/ Dissolve/70/gravity/center ">

12 after changing the color, that's it.

Summarize:

has been the second study of how to draw the Gantt Chart, the first time or use a half-day, this time also used, the effect of their own or very comfortable, what you have not learned?! Never mind. Look, you see the article at the end, give you a template

Template Download: http://yunpan.cn/cZhxSIezD5q7i (Extract code: 87FA)

———————————————————————————— chenchen!

！ ————————————————

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

Excel Country Gantt Chart (multi-image)