How to create vertical marker lines at specific x-axis values on a stacked area chart in Excel?

Solution 1:

This solves the issue:

:Caveat:

Combo Chart is the best option for the issue, readers may suggest another one.

How it works:

• First select B19:D29 & draw Staked Area Chart.

• Create one Helper Column like I've in Column F & used formula is:

  =IF(ISBLANK(E20),0,100)

• This formula gets Numeric value 100 for every Yes, since Graph only uses Numeric data, and 100 is editable, for tallest & proper visibility 100 has been used.

• Now Copy F19:F29, select Graph then use Paste.

• Select Graph, Right click then select Change Chart Type.

• Under the Chart category now select type is COMBO, for Helper Column select Clustered Column.

• Finally select Clustered Column Bar & Right Click, then hit Format Data Series, and set at Gap Width at maximum ( is 500 ), will make bar thinnest, you may set Gap Width as needed.

N.B.

• You may use as many data columns.
• For proper Visualization I've used small Data Set.
• You may hide the Helper Column.