98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Build a calendar based on an excel table
Build a calendar based on an excel table
Resolved · High Priority · Version 2016
Fri 22 Sep 2017, 12:53Delegate Orsi said...
Orsi has attended:
Excel Advanced course
Excel VBA Introduction course
Build a calendar based on an excel table
Is it possible to build a dynamic calendar in excel that sources its data from a table? The calendar should show a bar that represents each line in the table. The bars should extend from the start date to the end date (both listed in the table) and be labeled with the text listed in the first column of the table. Ideally the bars would be labeled differently by color depending on the category (also listed as one of the columns in the table)
Fri 22 Sep 2017, 13:32Trainer Jens said...
RE: build a calendar based on an excel table
Hi Orsi,
Thank you for the forum question.
I think you are looking for a Gantt Chart. MS Project is the right tool for Gantt charts but it can be done in Excel.
I have attached 2 files to the answer where you can find two different solutions.
In one of the files it is based on a PivotTable and a Pivot Chart and in the second it is done using Conditional Formatting.
I hope the files make sense.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
Project Chart (1).xlsxThu 28 Sep 2017, 11:09Trainer Wendy said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 5 Oct 2017: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formula for last day of monthIn some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1 |
