Hi - I have produced a graph from the table below and have an issue with the GM to Date row, whereby the Graph drops to 0 from Nov 22 How do I change it so that the line just stops in October?
Thanks
Thanks
| Year | RISK | 22/23 | ||||||||||
| Month | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 |
| Budgeted/Tendered GM plan | £ 64,382 | £ 23,000 | £ 32,000 | £ 72,000 | £ 45,000 | £ 34,000 | £ 21,000 | £ 64,382 | £ 23,000 | £ 32,000 | £ 72,000 | £ 45,000 |
| GM to date | £ 54,382 | £ 2,957 | £ 27,406 | £ 65,127 | £ 53,261 | £ 27,709 | £ 14,677 | |||||
| GM forecast | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ 19,248 | £ 107,029 | £ 130,459 | £ 143,284 | £ 138,166 |
| Potential GM improvement | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ 94,322.03 | £ 104,427.97 |
