How to Create an Interactive Wave Timeline Chart in Excel, by ExBiSheets on YouTube. 17 min 58 s.
- Video length
- 17 min 58 s
- Time to do it
- 45 minutes
- Difficulty
- Medium
- Steps
- 10
What you need
Steps
Set up a table with columns for task name, start date, end date, duration and a status column. Enter each milestone as one row.
Enable the Developer tab: go to File, Options, Customize Ribbon and tick Developer. This gives you the checkbox control.
Add a checkbox next to each task using Insert, Form Controls, Check Box. Right-click each box, choose Format Control and link it to the status cell for that row.
Create a helper column that returns 1 when the checkbox is ticked and 0 when it is not. Use a formula like =IF(status=TRUE,1,0).
Build the wave shape by plotting each task's start and end dates as a scatter chart with smooth lines, so the line rises and falls across the timeline.
Set the horizontal axis to a date scale and format it to show months or weeks. Adjust the axis minimum and maximum to cover your project dates.
Add a progress bar using a second helper range: count completed tasks and divide by the total. Show it with a bar chart or a data bar in a cell.
Tie the chart to the helper columns so ticking a checkbox changes the plotted values. Test it by ticking and unticking a box.
Format the chart: remove gridlines, set a clean line colour, add data labels for milestones and place the progress bar beside the chart.
Save the workbook as.xlsx. If you share it, keep the checkbox cells unlocked so others can tick tasks.
Tips and common mistakes
Link each checkbox to its own cell, not a shared one, or all tasks will tick together.
Keep the helper columns on a separate sheet so the chart data stays tidy.
Smooth lines can overshoot real dates, so check the curve against your milestone points.
Test the file on another computer, since form controls can behave differently across Excel versions.
Questions
Do I need the Developer tab for this?
Yes, the checkbox control lives there. You can enable it once in File, Options, Customize Ribbon.
Will this work in Excel for the web?
Form control checkboxes are limited in the browser version. Build and edit the file in desktop Excel, then open it online to view.
How is this different from a Gantt chart?
A Gantt chart uses flat bars. This chart plots the dates as a smooth wave line, which some people find easier to scan for milestones.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
