Hi all. I'm trying to set up a basic line graph which shows my cumulative pension amount, which starts from June '22 until now. I didn't start tracking the pension value monthly until Jan '24. When I add the pension value to the graph it automatically starts from the same date as the cumulative data. How do I get it to start on the graph from Jan 24?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Line Graph query
- Thread starter misterzim
- Start date
Sure,
You see the red line starts at Jun '22 rather than Jan '24?
| Month | Cumulative Investment | Fund Value |
| Jun 22 | £ 10.00 | £ - |
| Jul 22 | £ 20.00 | £ - |
| Aug 22 | £ 30.00 | £ - |
| Sep 22 | £ 40.00 | £ - |
| Oct 22 | £ 50.00 | £ - |
| Nov 22 | £ 60.00 | £ - |
| Dec 22 | £ 70.00 | £ - |
| Jan 23 | £ 80.00 | £ - |
| Feb 23 | £ 90.00 | £ - |
| Mar 23 | £ 100.00 | £ - |
| Apr 23 | £ 110.00 | £ - |
| May 23 | £ 120.00 | £ - |
| Jun 23 | £ 130.00 | £ - |
| Jul 23 | £ 140.00 | £ - |
| Aug 23 | £ 150.00 | £ - |
| Sep 23 | £ 160.00 | £ - |
| Oct 23 | £ 170.00 | £ - |
| Nov 23 | £ 180.00 | £ - |
| Dec 23 | £ 190.00 | £ - |
| Jan 24 | £ 200.00 | £ 210.00 |
| Feb 24 | £ 210.00 | £ 220.00 |
| Mar 24 | £ 220.00 | £ 230.00 |
| Apr 24 | £ 230.00 | £ 240.00 |
| May 24 | £ 240.00 | £ 250.00 |
You see the red line starts at Jun '22 rather than Jan '24?
Upvote
0
awoohaw
Well-known Member
- Joined
- Mar 23, 2022
- Messages
- 4,862
- Office Version
- 365
- Platform
- Windows
- Web
Thanks for the data. Change your values with no data to =NA() instead of zeros.
I think that is what you're asking about.
| Book1 | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | Month | Cumulative Investment | Fund Value | ||
| 2 | Jun-22 | £ 10.00 | #N/A | ||
| 3 | Jul-22 | £ 20.00 | #N/A | ||
| 4 | Aug-22 | £ 30.00 | #N/A | ||
| 5 | Sep-22 | £ 40.00 | #N/A | ||
| 6 | Oct-22 | £ 50.00 | #N/A | ||
| 7 | Nov-22 | £ 60.00 | #N/A | ||
| 8 | Dec-22 | £ 70.00 | #N/A | ||
| 9 | Jan-23 | £ 80.00 | #N/A | ||
| 10 | Feb-23 | £ 90.00 | #N/A | ||
| 11 | Mar-23 | £ 100.00 | #N/A | ||
| 12 | Apr-23 | £ 110.00 | #N/A | ||
| 13 | May-23 | £ 120.00 | #N/A | ||
| 14 | Jun-23 | £ 130.00 | #N/A | ||
| 15 | Jul-23 | £ 140.00 | #N/A | ||
| 16 | Aug-23 | £ 150.00 | #N/A | ||
| 17 | Sep-23 | £ 160.00 | #N/A | ||
| 18 | Oct-23 | £ 170.00 | #N/A | ||
| 19 | Nov-23 | £ 180.00 | #N/A | ||
| 20 | Dec-23 | £ 190.00 | #N/A | ||
| 21 | Jan-24 | £ 200.00 | £ 210.00 | ||
| 22 | Feb-24 | £ 210.00 | £ 220.00 | ||
| 23 | Mar-24 | £ 220.00 | £ 230.00 | ||
| 24 | Apr-24 | £ 230.00 | £ 240.00 | ||
| 25 | May-24 | £ 240.00 | £ 250.00 | ||
Sheet2 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C2:C20 | C2 | =NA() |
| A3:A25 | A3 | =EDATE(A2,1) |
I think that is what you're asking about.
Attachments
Upvote
0
Similar threads
- Question
