To make a floating stacked bar chart in Excel for Microsoft 365 on Windows, create a stacked bar chart with two series: a starting value and a bar length. Format the starting-value series with no fill, so it becomes an invisible offset and the visible bar appears to float between its start and end.
What a floating stacked bar chart shows
A floating bar represents an interval rather than a value that begins at zero. Its position shows where the interval starts on a numeric scale, and its length shows how far it extends. For example, a bar from 12 to 19 begins at 12 and ends at 19; it does not mean the value is 7 by itself, even though its length is 7.
Excel does not offer a separate chart type named Floating Stacked Bar. The usual method uses the built-in Stacked Bar chart and hides its first series. A regular clustered bar starts each bar at the axis baseline, while a stacked bar layers series end to end. Hiding the first layer leaves the next layer visible only across the desired interval.
This technique is useful for schedules, ranges, project phases, comparison bands, and minimum-to-maximum values. A Gantt chart is a common example: the invisible series represents the number of days from the chart’s starting date to a task’s start, and the visible series represents the task duration.
How the hidden offset works
Each category needs two chart values: an offset and a width. The offset is the interval’s lower bound, and the width is its upper bound minus its lower bound. Excel stacks the width after the offset. If the offset is 12 and the width is 7, the stacked total reaches 19. Hiding the offset makes the visible portion run from 12 to 19.
The standard approach works best when offsets and widths are nonnegative numbers and each width is greater than zero. It is not a special floating-bar calculation inside Excel; the chart is drawing two stacked series and one is simply invisible. That distinction matters when you edit the data or troubleshoot a chart that seems to start at zero.
Prepare the worksheet data
Set up a small table with one row per category. For example, use columns A through D for Category, Start, Finish, and Length. Enter these sample rows:
- Design: Start 3, Finish 8
- Review: Start 6, Finish 11
- Delivery: Start 10, Finish 15
With start values in B2:B4 and finish values in C2:C4, enter =C2-B2 in D2 to calculate the length. The Design row returns 5 because 8 minus 3 is 5. Fill the formula down through D4; the other two lengths are also 5. For a different example, a start of 12 and finish of 19 returns a length of 7.
Keep the chart’s category labels in one column and make sure every start and length is a real number, not text that merely looks numeric. Avoid blank rows inside the data. If you have endpoints that include decimals, the same subtraction works; choose an axis number format that makes those increments readable.
Create the stacked bar chart in Excel
- Select the category and start columns, including their headers; for the sample, select A1:B4.
- Choose Insert > Insert Column or Bar Chart > 2-D Bar > Stacked Bar. Do not choose 100% Stacked Bar, which normalizes the series to percentages.
- Click the chart, then choose Chart Design > Select Data.
- In the Select Data Source dialog, choose Add. Set Series name to the Length header in D1 and Series values to D2:D4, then confirm. Set the Horizontal (Category) Axis Labels to A2:A4 if Excel has not already used those labels.
- Confirm the dialog. The chart now has a Start series and a Length series. The bars may initially look like ordinary stacked bars because the Start series is still visible.
Ribbon labels can vary slightly with window size and Excel updates, but the chart type and Select Data workflow are available in desktop Excel for Microsoft 365 on Windows. Excel for Mac also supports stacked bar charts and series formatting; the ribbon or pane layout can differ slightly. The instructions here use the Windows ribbon names.
Hide the offset and format the chart
Click a Start segment in the chart. If selecting the individual series is difficult, use the chart’s Format tab and its Current Selection control to choose the Start series. Open Format Data Series, then go to Fill & Line > Fill > No fill. Set Border > No line as well, so the offset does not leave an outline. The Length bars should now appear to begin at their Start values.
- Remove the legend if it adds clutter, or edit the series names to make the visible series clear. A legend entry for a transparent series can confuse readers.
- Use Chart Design > Add Chart Element to add a chart title or axis titles where useful.
- Adjust the horizontal value axis bounds and major units in Format Axis. A sensible minimum and maximum can make small intervals easier to compare.
- Adjust the bar spacing in Format Data Series > Series Options > Gap Width. A smaller gap makes bars thicker; it does not change their values.
- For readable category order, open the vertical category axis formatting options and select Categories in reverse order if the first worksheet row appears at the bottom.
To label a bar with its finish rather than its length, remember that a normal data label on the Length series reports the length. You can add labels from cells in supported desktop Excel versions: select the visible series, add data labels, open Format Data Labels, and use Value From Cells to select cells containing the desired text or finish values. If that option is not available in your Excel build, use a text box or label the chart through another method rather than implying the length is the endpoint.
Example: a simple project schedule
Suppose a project has three tasks measured in workdays from day zero. Design runs from day 3 through day 8, Review from day 6 through day 11, and Delivery from day 10 through day 15. The lengths are 5, 5, and 5 days. In the chart, the hidden offsets position the visible bars at 3, 6, and 10; the visible portions end at 8, 11, and 15.
This makes overlap easy to see: Design and Review overlap from day 6 to day 8, and Review and Delivery overlap from day 10 to day 11. A table of task durations alone would not show those positions. However, a bar chart does not determine task dependencies or automatically calculate a project schedule. Those relationships still need to be represented and maintained in the worksheet or a scheduling tool.
Using dates and other ranges
Excel stores dates as serial numbers, so dates can serve as offsets in a stacked bar chart. For a Gantt-style view, use actual start dates as the offset and a duration in days as the visible series. Set the horizontal axis number format to a date format so its serial values display as calendar dates. The display depends on the workbook’s date system and regional settings, so check that the axis labels match the dates in your source data.
For date durations, make sure the duration unit matches the date scale. A duration entered as a number of days can be stacked after a date serial. If tasks are measured in hours, weeks, or business days, decide how those units map to Excel dates before charting. A simple subtraction of two dates gives elapsed calendar days; it does not automatically exclude weekends or holidays.
The same design works for positive numeric ranges such as a price band, delivery window, or measurement interval. Use the lower value as the offset and upper minus lower as the width. It is less suitable for intervals that cross zero or have negative widths: stacked bars handle positive and negative series on opposite sides of zero, so the hidden-offset trick may no longer create the intended continuous interval. For those cases, consider a scatter chart with error bars or another range-focused visualization.
Common problems and how to fix them
- Bars still begin at zero: The Start series may still have a fill, or the chart may be Clustered Bar rather than Stacked Bar. Check both the chart type and the Start series’ Fill setting.
- The bar lengths look wrong: Confirm that the visible series contains Finish minus Start, not the Finish values themselves. Stacking Start and Finish would extend the bar to Start plus Finish.
- Categories or series are reversed: Use Chart Design > Select Data to check the axis-label range and series ranges. Reverse the category order in Format Axis if needed.
- The first task appears at the bottom: This is often just the default category order for a horizontal bar chart. Reverse the vertical category axis order to put it at the top.
- The chart includes a zero-based axis that wastes space: Set a suitable minimum bound on the horizontal value axis. Do not set it so tightly that viewers lose important context about the scale.
- Dates show as large numbers: Format the horizontal axis as dates. The chart uses date serial values internally, so a number format is needed to show calendar dates.
When another chart type is a better choice
A floating stacked bar is useful when the interval’s position and length are both important and categories are easy to compare. A standard stacked bar is better when every series starts at the same baseline and the parts add up to a meaningful total. A clustered bar is preferable when you want to compare separate values side by side, not show a continuous interval.
For a few ranges on a numeric axis, a scatter chart with horizontal error bars can show endpoints while keeping the axis relationship explicit. For a project plan with dependencies, milestones, and calendar rules, a dedicated project-management tool may communicate more than a manually maintained Gantt-style chart. The best choice depends on whether the reader needs to compare categories, see a distribution, or follow a schedule.
Frequently Asked Questions
Can Excel make a floating bar chart without a workaround?
There is no separate built-in chart type called Floating Bar. The common Excel method is a Stacked Bar chart with the first, offset series set to No fill and No line.
What is the difference between a floating bar and a Gantt chart?
A Gantt chart is a schedule view that often uses the same floating-bar technique: a hidden start offset followed by a visible duration. The chart method is similar, but a Gantt chart’s data and purpose are specifically about tasks over time.
Why does my floating bar show the wrong endpoint?
Check that the visible series is the interval width, calculated as finish minus start. If you stack the finish value instead, Excel adds it to the start and the visible bar ends too far along the axis.
Can I use dates for the floating offset?
Yes. Excel dates are numeric serial values, so a start date can be the offset and a duration in days can be the visible series. Format the horizontal axis as dates and confirm that your duration unit is appropriate.
Can I make a floating bar that crosses zero?
The simple hidden-offset method is designed for nonnegative offsets and positive widths. Intervals crossing zero can behave differently because Excel stacks negative values separately; a scatter chart with error bars is often a better option.
Related
- Excel Data Validation List: How to Exclude Blanks in Excel
- Excel Data Validation List From Another Sheet: Steps
- Excel Data Validation List From a Table Column Explained
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Basic Excel Line Chart: Create and Format OneTo make a basic line chart in Microsoft Excel for Microsoft 365 on Windows, arrange time periods in…
- Excel Graph Y-Axis Not Starting at Zero? How to Fix ItTo make an Excel graph’s vertical axis start at zero, right-click the value axis, choose Format Axis, and…
- Excel Pivot Table Date Filter by Month: Steps and FixesTo filter an Excel PivotTable by month, place a real date field in Rows, open its field dropdown,…
- Power Pivot Column Formatting: Set Formats That StickIn Excel for Microsoft 365 on Windows, open the Power Pivot window, select the column, then choose a…
- Excel Waterfall Chart Template: Build and Customize OneYes. In Excel for Microsoft 365 on Windows, select a category-and-value table, then choose Insert > Insert Waterfall,…
- Excel Bar Chart in Descending Order: Sort It CorrectlyTo put an Excel bar chart in descending order, sort the chart’s source data from largest to smallest:…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.