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)
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).xlsxWill 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.
