Roadmap Examples in Excel: 4 Layouts You Can Build with Formulas and Charts

6 min read ยท 2026-10-09

You can build four roadmap examples in Excel with built-in features only: a swimlane grid, a Gantt-style bar chart, a milestone timeline and a Now/Next/Later board. They use a conditional formatting formula, a stacked bar chart, a scatter chart with error bars, and the FILTER function with a Data Validation drop-down.

All four read from the same "Data" sheet. When you change a date or a status there, the roadmap updates on its own. This guide gives you the setup first, then the exact formulas and chart settings for each layout. If you would rather skip the formatting work, Generate your roadmap with AI (first one free).

The roadmap at a glance

Goal: Build one roadmap file where you update data in one place and the visual follows. Duration: 4 steps in one workbook

  1. Prepare the Data Sheet (Step 1)

    Put every initiative in one row with real dates and a stage.

    • Create a sheet named "Data" with these columns: Theme, Initiative, Owner, Start, End, Stage, Milestone.
    • Enter real dates in Start and End, not text. Check with =ISNUMBER(D2), which should return TRUE.
    • In Stage, keep one of three values: Now, Next or Later.

    Milestone: Every initiative has an owner, a start date and an end date in one row.

  2. Convert It Into an Excel Table (Step 2)

    Make the data grow without breaking formats, formulas or charts.

    • Click inside the data and go to Insert, Table. Tick "My table has headers".
    • Rename it "Data" in Table Design, Table Name.
    • Select the Stage column and add Data, Data Validation, List, with Source: Now,Next,Later.

    Milestone: New rows get the same format and drop-down automatically.

  3. Build the Visual (Step 3)

    Link the roadmap view to the Table so it updates on its own.

    • Add a "Roadmap" sheet and build one of the four layouts below.
    • Link it to the Table with formulas. Never type dates straight into the visual.

    Milestone: Changing one date on "Data" moves the right bar or cell on "Roadmap".

  4. Export to PDF (Step 4)

    Share a clean one-page version with people who don't use Excel.

    • Go to Page Layout, set Orientation to Landscape, and set Width to 1 page.
    • Select the roadmap and go to Page Layout, Print Area, Set Print Area.
    • Add a "Last updated" cell with today's date, then go to File, Export, Create PDF/XPS.

    Milestone: People who don't use Excel get a one-page PDF that reads clearly.

Example 1: The Swimlane Grid (Conditional Formatting)

This layout uses no chart at all. Rows are initiatives grouped by theme, columns are months, and a formula colors the cells.

On the "Roadmap" sheet, put themes in column A and initiatives in column B. Pull the start date into column C and the end date into column D, for example with =XLOOKUP(B2,Data[Initiative],Data[Start]). In E1, type the first day of your first month. In F1, enter =EDATE(E1,1) and copy it across.

Select the grid from E2 onward. Go to Home, Conditional Formatting, New Rule, "Use a formula to determine which cells to format", and enter: =AND($C2<=EOMONTH(E$1,0), $D2>=E$1)

This fills every month the initiative touches, even if it starts mid-month.

Use custom number format mmm yy on row 1 so headers stay short.

  • Add one rule per theme color with =AND($A2="Growth", $C2<=EOMONTH(E$1,0), $D2>=E$1).
  • Add a rule to highlight the current month: =E$1=EOMONTH(TODAY(),-1)+1.
  • Use View, Freeze Panes on cell E2 so dates and names stay visible.

Example 2: The Gantt-Style Bar Chart (Stacked Bar)

Excel doesn't have a predefined Gantt chart type. Microsoft's own guide shows how to simulate one with a stacked bar chart (Present your data in a Gantt chart in Excel, Microsoft Support).

Add a Duration column to the Table with =[@End]-[@Start]. Select Initiative, Start and Duration, then go to Insert, Recommended Charts, Stacked Bar. Click the Start series and set Shape Fill to No Fill. Only the duration bars stay visible, and they float at the right dates. Right-click the vertical axis, choose Format Axis, and tick "Categories in reverse order".

Because the chart reads from a Table, new rows show up in the chart without editing the range. Not sure you need bars at all? See roadmap vs Gantt chart to decide. If your team plans sprint by sprint, an agile roadmap is a better fit than fixed bars.

Halfway there and still fighting with chart settings? Generate your roadmap with AI (first one free), then adjust phases and milestones by drag and drop.

  • Fix the empty space on the left: type your first date in a spare cell, format it as General, and copy that number into Format Axis, Bounds, Minimum.
  • Show owners on the bars: Add Data Labels, then Format Data Labels, tick "Value From Cells" and select the Owner column.
  • Color by theme: click one bar twice to select only that point, then change its fill.

Example 3: The Milestone Timeline (Scatter Chart and Error Bars)

This layout shows only key dates on one horizontal line. It takes the most chart settings of the four.

Filter the Table to rows marked as milestones, or list them on a small range: Date, Label, Height. Fill Height with alternating values such as 1, -1, 2, -2 so labels don't overlap. Select Date and Height and go to Insert, Scatter.

Then click the chart, open Chart Elements (the plus button), tick Error Bars and choose More Options. Select the vertical (Y) error bars and set Direction to Minus, End Style to No Cap, and Error Amount to Percentage, 100%.

Each point now has a line down to the axis. Delete the horizontal error bars. Add data labels, tick "Value From Cells" and select the Label column.

Showing this to leadership? Read how to present a roadmap to executives.

  • Hide the vertical axis and the gridlines for a clean line.
  • Add a "Done" column and a second series for reached milestones, with a different marker.
  • Once it works, save it with File, Save As, Excel Template (.xltx) so you never rebuild the settings.

Example 4: The Now/Next/Later Board (FILTER and Data Validation)

This board groups work by priority, not by date. In Excel, the Stage drop-down from Step 2 does all the work.

On the "Roadmap" sheet, type Now, Next and Later in A1, B1 and C1. In A2, enter: =FILTER(Data[Initiative], Data[Stage]=A$1, "Empty")

Copy it to B2 and C2. Each column spills the matching initiatives. When an owner changes Stage from Next to Now on the "Data" sheet, the item moves column by itself. FILTER is available in Microsoft 365 and recent versions of Excel. In older versions, filter the Table by Stage and copy the result.

The method behind this layout is explained in our guide to the Now-Next-Later roadmap.

  • Sort inside each column with =SORT(FILTER(...)) to keep a stable order.
  • Turn on Wrap Text and set the same column width so every card looks alike.
  • Color cards by theme with a conditional formatting rule that looks up the theme with XLOOKUP.

Which Layout Is Easiest to Maintain in Excel

Ready to skip the spreadsheet setup? Generate your roadmap with AI (first one free).

  • Swimlane grid: only formulas. It is the hardest to break, and anyone can edit it.
  • Now/Next/Later board: only formulas. Owners just change one drop-down.
  • Gantt bars: chart-based. It stays stable if it reads from a Table.
  • Milestone timeline: chart-based, with the most settings. Save it as a template.

Common mistakes to avoid

  • Dates stored as text break every formula and chart, so check them with ISNUMBER.
  • A chart built on a fixed range ignores new rows, so build it on an Excel Table.
  • Merged cells break sorting and FILTER, so use "Center Across Selection" instead.
  • Hard-coded colors don't follow date changes, so use conditional formatting rules.
  • An unset print area splits the roadmap across pages, so set it before you export the PDF.

Frequently asked questions

Does Excel have a built-in roadmap template?

Excel has no roadmap chart type. You build one from cells, conditional formatting or a stacked bar chart, as shown in the four layouts above. For the bar version, Microsoft explains how to turn a stacked bar chart into a Gantt-style view (Microsoft Support).

Which roadmap example in Excel is easiest for beginners?

The swimlane grid. It uses cells, dates and one conditional formatting formula. There is no chart to configure.

Can I build a roadmap online instead of in desktop Excel?

Yes. Save the file to OneDrive and open it in Excel for the web, so your team can edit it in a browser. Google Sheets also works. It supports conditional formatting with a custom formula: go to Format, Conditional formatting, then pick "Custom formula is" in the "Format cells if" menu. Some chart options have different names or locations online, so check your charts after you open the file.

How often should I update an Excel roadmap?

Update it every time a date or priority changes, and review it at least once a month. Change only the "Data" sheet and the visual follows. Before big changes, save a dated copy.

Generate this roadmap with AI