Add a vertical line to a line graph

user16684
user16684 Member
in Charting

My data returns the amount expensed per month for the past months. The current month and remaining months for the year show the projected remaining budget. Is it possible to do either of the following?

 

- Add a vertical line on the current month to show that the line is now showing projected budget, not actual amount expensed.

- Have the line change color once it hits August (the current month).

 

Thank you!

 

 

Comments

  • swagner
    swagner Contributor

    My first thought is to use series & color rules to plot two lines on the card.  Then write a beast mode with a case statement to determine if the date is in the past, or in the future.  Suppress the lines so that:

    • The past values are "Actual" and are represented by a green line (Jan thru Jul shows that line).
    • The future values are "Budget" and are represented by a blue line (Aug thru Dec shows that line).

     

    Am I understanding your question? 

  • user16684
    user16684 Member

    Yes, I believe you are understanding. For the case statement, what would you have as the output? If it's a past month, then ___ ?

This discussion has been closed.

Categories