Independent Targets in Line Graph

Edward4

New Member
Joined
May 31, 2019
Messages
1
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 (y). 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.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,089,237
Messages
5,407,069
Members
403,121
Latest member
TimKromer

This Week's Hot Topics

Top