How to Plot a Person's Time Span with a Floating Bar Chart in WPS Office Spreadsheet
Question details
The user wants to display each person's stay or activity period on a timeline as a floating horizontal bar chart by using a start date offset and a visible duration series.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- Plotting duration data for people on a timeline in a bar chart.
- Observed behavior
- The desired result is a floating horizontal bar for each person showing only their stay or activity duration rather than the full start-date offset.
Open WPS Office Spreadsheet and arrange your data in columns for Person, First Positive Date, Discharge Date, and Time in Days. Make sure the date columns are formatted as dates and the duration column contains numeric values.
Create a Floating Bar Chart with a Transparent Start Date Series
Use this method when you have a start date and a duration for each person and want only the duration to appear on the timeline.
A stacked bar chart can simulate a floating bar by plotting the start date as the first series and the duration as the second series. Formatting the first series with no fill hides the offset, making the duration segment appear to float.
Create columns for Person, First Positive Date, Discharge Date, and Time in Days in WPS Office Spreadsheet.
Select the Person, First Positive Date, and Time in Days columns, go to the Insert tab, and choose Bar > Stacked Bar.
Right-click the chart, choose Select Data, and make sure First Positive Date is the first series and Time in Days is the second series.
Right-click the First Positive Date bars, choose Format Data Series, and set Fill to No fill and Border to No line.
Right-click the horizontal axis, choose Format Axis, and set the Axis Type to Date axis so the timeline reflects the correct date range.
Confirm the vertical axis shows the Person names. If not, right-click the chart, choose Select Data, and set the Category axis labels to the Person column.
Create Floating Bar Charts in WPS Office Spreadsheet
Use a transparent stacked bar offset series in WPS Office Spreadsheet to plot each person’s stay or activity period as a clean floating horizontal bar.
- 1. Insert a stacked bar chart: In WPS Office Spreadsheet, select the data area and click the Insert tab, then choose Bar and Stacked Bar.
- 2. Open Select Data: Right-click the chart and choose Select Data to arrange First Positive Date and Time in Days in the correct series order.
- 3. Hide the first series: Right-click the First Positive Date bars, choose Format Data Series, and set Fill to No fill.
- 4. Format the axis: Right-click the horizontal axis, choose Format Axis, and set it to a date scale.
Frequently Asked Questions
Why does my floating bar chart show the start date as a full bar?
The first series still has a visible fill. Right-click the First Positive Date bars, open Format Data Series, and set Fill to No fill and Border to No line.
How do I get the horizontal axis to show dates instead of numbers?
Right-click the horizontal axis, choose Format Axis, and set the Axis Type to Date axis. Then adjust the minimum and maximum bounds to cover your date range.
Can I create a floating bar chart without a hidden stacked series?
WPS Office Spreadsheet does not have a dedicated floating bar chart type. The transparent first series in a stacked bar chart is the standard workaround.
How do I display each person’s name on the vertical axis?
Make sure the Person column is selected as the category axis labels. Right-click the chart, choose Select Data, and edit the Category axis labels to include the Person cells.
Does this method work with Microsoft Excel files?
Yes. You can open an Excel XLSX workbook in WPS Office Spreadsheet, apply the same stacked bar chart settings, and save the file back in Excel-compatible format.
