How-to Add a Line to an Stacked Clustered Column Chart in Excel

Download the sample file and check out the written tutorial here:

Learn how to quickly add a target line to your Clustered Stacked Column Chart in Excel.

Show Notes:

[conanbarbarian]

I don't usually comment but this was a real life saver. Never used charts before and needed to change an existing chart someone else had built. Was too complicated to reverse engineer so started from scratch. This plus the stack column tutorial worked exactly how i wanted. Thank you

[anhtran]

Thanks for the helpful video. It's annoying that some Excel's features are not particularly intuitive.

[kylielake]

Hi this was interesting thanks, I have a bar Chart and can't work out how to make the line vertical?

[joedi]

How would you add a vertical line to a stacked chart without using shapes? Thanks.