How to add a hor line on my 8020 chart ?

[#1]

Hi All

I need to draw a horz line on my 8020 chart. any idea ? like the green line i add manually

Paul

[#2]

See attached. You should use the trendline.

[#3]

Hi Sir

you line 20% work for the chart , but if i change my dim to segment , the % vari. How to fix it ?

Paul

[Sokkorn · Accepted solution]

Hi Mr Paul,

I would suggest you to change some setting for easy manage reference line. Like this

1. Go to Axes tab and select expression then change position

  a. [Inclusive Percentage] -> Position = Left

  b. [Sales] -> Position = Right

2. Go to Presentation tab and add "Reference Lines"

See sample attached file also.

Regards,

Sokkorn

[#5]

very perfect ans.