The chart is a normal stack bar chart, with the green progress bar is made with the error lines and the red bar is linked with column T.Column R is the number of days you actually took to complete the task.Column O and P are from the actual table itself.Column N includes column B and criteria in cell B20 and its string concatenation with the number of days.Column L is how much of that chapter/task you have completed.The two tables Planned and Actual is how you want your inputs and data to be.Also, I added another bar to showcase the overdue part in red as suggested by u/savannafields84Įxplanation: (I am not very good at explaining, but I can explain if you have any specific doubt.) This is the actual version on the go of how much I have actually completed.Įdit: I have tried to explain how I did it if anyone was curious. This is the planned version of how many days it would take to complete my Automate the Boring Stuff with Python would take. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Id love to get some feedback on this and hear input on what features you would want in a Gantt chart/project management tool. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date ![]() Or use tableit, or the ExcelToReddit converter (thanks to u/tirlibibi17), to convert your data into a Reddit table. Provide some dataĪdd screenshots in your text post, or provide links to uploaded images at an image-hosting site. Tip: For VBA or Power Query, select the code, press Tab, then copy/paste the selection into your post or comment. The best way to display code on Reddit is to put it in a code-block This awards the user a ClippyPoint and changes the post flair to solved. OPs may (and should) reply to any solutions saying: Solution Verified
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |