Mark margins in line chart

Hello ,

Using a line chart or column chart. If you have % ( from 0 to 150) on vertical axis, and I want to mark the margin area between 95% to 105% . I waould like to mark this area in a color in order to easily see when my lines/colums are within the margin or not. any idea , how I should handle this? thanks in advance.JochenB

Hi JochenB,

Welcome to the forums.

Here is a step-by-step tutorial and a video tutorial showing you how to create a horizontal band on your chart:

How-to Create a Dynamic Banding on an Excel Line Chart

Please let me know if this helps.

Steve=True

Hi Steve,
Thank you very much for the step by step tutorial . This is exactly waht I wanted .Its a real clear job aid . Howver , following the steps and applying to the data I have, I have the bandwith of 10% ( between 95% and 105%) on the bottom of my chart ( between 0% and 10%)instead. Any idea what I did wrong ?

Hi JochenB,

So glad it helped.

I would imagine that you either don't have the NO FIll series in your chart or you have them in the wrong order.

Let me know how it turns out.

Steve=True

Hi Steve , it works now thanks. Indeed I had the No Fill series in the wrong order.CHeers

JochenB