Hello All,
I'm wanting to create a line graph which show a cumulative forecasted value of spend of time (simple enough!). However, I want to include independent cumulative value of year end budgets where lines plot back to both axis (e.g. Year 1 (x) and £1m
. The idea is that the graph will plot when the forecasted spend will exceed the year end budget.
Plotting the "budget" as a separate cumulative line is not preferable as this will only have five data points in the example below, whereas the forecast line will have 65 (13 periods in financial year).
Thanks for any help in advance.
I'm wanting to create a line graph which show a cumulative forecasted value of spend of time (simple enough!). However, I want to include independent cumulative value of year end budgets where lines plot back to both axis (e.g. Year 1 (x) and £1m
. The idea is that the graph will plot when the forecasted spend will exceed the year end budget.Plotting the "budget" as a separate cumulative line is not preferable as this will only have five data points in the example below, whereas the forecast line will have 65 (13 periods in financial year).
Thanks for any help in advance.
