Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.