1 Reply Latest reply on Feb 22, 2018 11:14 PM by Norbert Maijoor

# How to Create Reference Lines (Instead of Shapes) on Horizontal Bar Chart

Hi.  How do I create vertical reference lines (instead of shapes) on a horizontal bar chart?  The reference lines would also ideally have the capability to annotate (to state what it is).  Keep in mind that every row of horizontal bars represents one person (so in the examples below, that is depicting one user) and the vertical lines will be different values for each person.   The good news is that each person will have the same amount of vertical lines (i.e., 3 like the example images below).  I illustrate that further below.

This is what I currently have:

This is what I want:

Person 1

Bar goes out to \$750,000

Manager Forecast line = \$150,000

Forecast line = \$220,000

Quota line = \$350,000

Person 2

Bar goes out to \$500,000

Manager Forecast line = \$80,000

Forecast line = \$110,000

Quota line = \$200,000

• ###### 1. Re: How to Create Reference Lines (Instead of Shapes) on Horizontal Bar Chart

Hi Kevin,

Find my approach as reference below and stored in attached workbook version 10.3 located in the original thread.

1. NM M1. Top First Level: [Goes Out]*0.33

2. NM M2. Top Second Level: [Goes Out]*0.66

3. Drag the required objects to the indicated locations

4. Define first band

5. Define second band

6. Define third band

7. Define Manager Forecast, Forecast & Quota

8. Format... Manager Forecast, Forecast & Quota