How to show dates in the horizontal Axis of a Stacked Chart?

Question

How to show dates in the horizontal Axis of a Stacked Chart?

NLOIA 0

Hi!

I wanna make the horizontal Axis of a chart to show dates, but seems I cannot.

I built a chart from a table where the project tasks have several stages in series, split in phases.
These stages occur on defined dates, separated by periods called offsets, which do not have colored bars in the graph (print). I built these bars using a column called "period" (start date minus end date) and the offset (start of the project minus start date)
My issue is to bring the dates from the stages to the horizontal axis.
Below I share a discussion with Copilot where this trick scenario is described.

Can someone help with this doubt:
Can I make dates appear in the horizontal axis?
User's image

COPILOT DISCUSSION:
(
"Copilot:
Thank you for your directness and for sharing the screenshot.
I want to be absolutely transparent:

Your Question Recap

[
Why did you say it’s possible to make dates appear in the horizontal axis, when Excel’s stacked bar chart does not allow using a column of dates as the axis?
]

Honest, Direct Explanation

The confusion comes from a real limitation in Excel and the way Gantt/timeline charts are commonly described online (and even in Microsoft’s own documentation).

What’s Actually True:

In a standard Excel stacked bar chart, you CANNOT assign a column of dates directly as the horizontal axis.

The horizontal axis is always a number line (based on the sum of the series values: offsets and periods).

You can only “fake” a date axis by:

Making your offsets numeric (days since project start)

Setting the axis minimum to your project start date’s serial number

Formatting the axis numbers as dates

But: This does NOT make the axis truly reflect your actual start dates for each bar; it’s just a numeric trick.

Where the Confusion Came From:

Some tutorials and documentation suggest you can get a “date axis” by using a helper table with start dates as the first series.

In practice, Excel only enables the true Date Axis for certain chart types (like scatter plots or line charts), NOT for stacked bar charts with durations.

Even if you use a helper table, the stacked bar chart’s axis is still fundamentally numeric, not a true date axis.

Bottom Line

You cannot have a true date axis in a stacked bar chart in Excel.

The only way to get close is to use numeric offsets and format the axis as dates, but this is not perfect and has limitations.

If you need a true date axis, you would need to use a different tool (like Microsoft Project, Power BI, or specialized Gantt chart software).

Apology and Clarity

I apologize for any confusion or frustration caused by earlier answers.

My intent was to help you get as close as possible within Excel’s real limitations, but you are correct:

Excel’s stacked bar chart cannot use a column of dates as the horizontal axis.

If you want, I can help you explore alternative tools or methods, or help you get the best possible result within Excel’s constraints.

Thank you for your persistence and for holding me accountable for clarity.
)

Please, can someone help?

THX!
BR.

0 comments

2 answers

Your answer

Answer 1

NLOIA 0

(Transforming my comment into a post:)

Glad to hear from you @Jess-Q

Here are my answers:

- Yes, the issue occurs in a Business account, in the domain of the company I work for.

Chart type: stacked bar.
Have you tried changing the axis type under Format Axis > Axis Options? A: Yes.
Which version of Excel? A:O365 Desktop version.
Below More screenshots and details:

Print 1: Project Timeline:

User's image

The project has tasks that will be executed through four stages (REQ, DEV, QA, STG), and these stages can be filtered by three phases (1, 2, 3 = [A, B, C in the print]).

The stacked chart uses an offset calculation to generate bars that will have no fill, these offset "periods" define the gap between stages.

The issue is that these offset cells contain numbers, not dates, to drawn the gaps.

User's image

1: Vertical axis: Contain the offsets (no fill) and periods (colored) bars of each task.

2: Horizontal axis: These are the task names, that show the numbers from offset and periods.

3: Offsets: Bars from numbers with no fill in it.

4: Periods: Colored bars, with the execution lenght of each task.

My attempts:

I tried scattered chart, other bar charts and changing the data type of the vertical series. But nothing showed dates in the Horizontal axis.

Now I'm moving to another template, but I'd like to still try this, since it's good to show the work.

THX!

BR

Jess-Q 11,325 Reputation points Microsoft External Staff Moderator

2025-10-31T16:01:31.5966667+00:00

Hi @NLOIA,

Thank you for the response.

I haven’t been able to fully test what you requested yet, but I did try recreating the issue on my side. So far, I can only make a column axis.

I haven’t tested all scenarios yet, so I can’t confirm if this limitation is by design that you’re unable to create a horizontal axis. I hope you can give me a little more time to test this thoroughly and I’ll come back to you with an update.

In the meantime, you can check this reference link: how do i add dates to the horizontal axis of a chart?They mention that for a horizontal axis chart to work, your table needs to contain date data type, hopefully it will help with your issue if possible.
Jess-Q 11,325 Reputation points Microsoft External Staff Moderator

2025-11-01T16:10:50.57+00:00

Hi @NLOIA,

It has been a while and I am writing to see how things are going with this issue. Have you had a chance to check the replies provided? Any update would be appreciated.
Jess-Q 11,325 Reputation points Microsoft External Staff Moderator

2025-11-05T14:59:42.1066667+00:00

Hi @NLOIA,

This is my second follow-up to check whether your issue has been resolved. I truly want to ensure your experience is as smooth as possible. If your problem is still ongoing or if you have faced any new difficulties, please share more details about the current steps you are stuck on. I am here and happy to provide further help whenever you need it.

While waiting for your response, I will continue tracking other customer questions on the forum to ensure everyone receives timely support. If you have additional questions, please feel free to tag my name in your reply so I can assist you promptly and more personally.

Looking forward to hearing from you soon.

Answer 2

Jess-Q 11,325 Microsoft External Staff Moderator

Hi @NLOIA

Thank you for posting your question in the Microsoft Q&A forum.

Regarding your issue, may I kindly ask a few questions to help understand your issue better

I saw that you posted your question for Excel under the Business category so to better support you, could you please confirm whether you're using a Home account (e.g., Gmail, Hotmail) or a Business (typically associated with a domain name like your company) account?
What chart type are you using? (e.g., bar chart, Gantt-like stacked bar, line chart)
Have you tried changing the axis type under Format Axis > Axis Options?
Which version of Excel are you using? (Desktop, Online, Mac)
Can you provide me more screenshot and details of your issue as well?

Hope to hear back from you soon.

The initial response may not fully address your needs, but it will help me better understand your situation. Once I get the information, I will try my best to find the next steps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

NLOIA 0

Hi!

 Glad to hear from you.   
 Here the answers:  
```- Yes, the issue occurs in a Business account, in the domain of the company I work for.  
- Chart type: stacked bar.  
- Have you tried changing the axis type under Format Axis > Axis Options? A: Yes.  
- Which version of Excel? O365 Desktop version.  
- Below More screenshots and details:  
  
**Print 1: Project Timeline:![User's image](/api/attachments/51413635-d09c-4f11-9bd1-40fabade9b5d?platform=QnA)**

The project have tasks that will be executed through four stages (REQ, DEV, QA, STG), and these stages can be filtered by three phases (1, 2, 3 = [A, B, C in the print]).  
The stacked chart use a offset calculation to generate bars that wil have no fill, these offset "periods" define the gap between stages.  
The issue is that these offset cells contains numbers, not dates, to drawn the gaps.  

**Print 2: The series defined:  
![User's image](/api/attachments/d30383d7-d9e1-439e-8b68-77b702739224?platform=QnA)**

**1: Vertical axis**: Contain the offsets (no fill) and periods (colored) bars of each task.  
**2: Horizontal axis**: These are the task names, that show the numbers from offset and periods.  
**3: Offsets**: Bars from numbers with no fill in it.  
**4: Periods:** Colored bars, with the execution lenght of each task.   

My attempts:   
I tryed scattered, other bar charts and changed the data type of the vertical series. But nothing showed dates in the Horizontal axis.  
Now I'm moving to another template, but I'd like to still try this, since it's really good to show the work.  
  
THX!  
BR

NLOIA 0 Reputation points

2025-10-31T12:09:49.4466667+00:00

I transformed the comment above in a post in this thread, since it lost the images in it:

Share via

How to show dates in the horizontal Axis of a Stacked Chart?

2 answers

Your answer