Dynamic Reference Line

[rajany089]

Hello Team, I need to create a dynamic reference line for a bar graph. The reference line should start at 73% for January 2024 and increase by 3% each month thereafter. Currently, I have data for two months, but I want the reference line to adjust automatically as new data is added. How can I achieve this without manual intervention, ensuring the reference line reflects the correct percentage for each month?

Code that i tried 

if (Month = 'Jan-2024' THEN '70%',
elseif Month = 'Feb-2024' THEN '73%',
elseif Month = 'Mar-2024' THEN '77%',
elseif Month = 'Apr-2024' THEN '80%',
elseif Month = 'May-2024' THEN '83%',
elseif Month = 'Jun-2024' THEN '87%',
elseif Month = 'Jul-2024' THEN '90%',
elseif Month = 'Aug-2024' THEN '93%',
elseif Month = 'Sep-2024' THEN '97%',
else '100%')
ENDIF

here month is column name 

[JonnyPoole]

Can you send a picture of what you want?  If the months are on the X axis the reference line would not be flat or constant.  Do you use the maximum month in the data set to calculate the reference line amount?  I think a picture might explain what you are after.