How to remove gap at the start and end of Excel area chart with multi-level axis?

Question

I'm trying to create an area chart in Excel that has a multi-level axis for the X-axis. For some reason, if I use a single level axis, my chart is created as desired:

But when I switch to a multi-level, a gap is inserted at the start and end of the chart:

Switching between "on tick marks" and "between tick marks" in axis options didn't help this either. Is there a way to fix this?

hansvogelaar · Answer

ANambs007&nbsp;
Instead of a multi-level axis, use values such as 2013Q4, 2014Q1, ..., 2021Q4 for the x-axis, and rotate the axis labels if necessary.

anambs007 · Answer

HansVogelaar&nbsp;Do you mean there's no solution to this? Because that seems more of a workaround than a solution

hansvogelaar · Answer

ANambs007&nbsp;
As far as I know there is no solution for a multi-level axis, so I suggested a work-around.

Forum Discussion

How to remove gap at the start and end of Excel area chart with multi-level axis?

3 Replies

Resources