Chart not responding & rouge black vertical line

[nighttrain20]

I'm having issues with my Excel 2016 version. ever since I changes from "12" my charts refuse to "chart past 7 months. is these a special setting I'm not aware of?

Also, I have a "rouge" vertical black line after the last vertical of data line. When I saved it as a PDF and looked at it, the black line isnot there. If there is a way to send this to someone for review, let me know. I'm in a jam here,

Thank you,

Tony

 

[RoryA]

ever since I changes from "12" my charts refuse to "chart past 7 months.

Could you explain exactly what that means please?

 

[nighttrain20]

Could you explain exactly what that means please?

I have selected for my chart, from 1/5 - thru "8/4" dates & deliveries but it wont chart past "7/6"- "64" its like it wont chart past 7 months. I've changed nothing and have been doing this chart for several years. I am using office 16 now. use to have 12.
Week Ending Deliveries
1/5 24
1/12 47
1/19 56
1/26 49
1/31 34
2/2 20
2/9 64
2/16 62
2/23 41
2/28 39
3/2 14
3/9 71
3/16 67
3/23 74
3/30 63
4/6 77
4/13 81
4/20 91
4/27 108
5/4 96
5/11 96
5/18 99
5/25 87
5/30 52
6/1 15
6/8 93
6/15 95
6/22 90
6/29 91
7/6 64
7/14 100
7/21 95
7/28 108
7/31 40
8/4 49

 

[nighttrain20]

Thanks for the help The dates on some of the data were reading 2017.
The only other problem is a black vertical line that's appearing on my charts I can not get rid of. It's at the end of my chart

 

[RoryA]

I think that will be hard to diagnose without the workbook. Can you put it online somewhere (e.g. Dropbox or OneDrive) and then post a link to it here?

 

[nighttrain20]

Thank you,

Here is the dropbox link. The vertical black line is on the chart called "Chart Title" in the backlog tab,

Thank you again


https://www.dropbox.com/s/o9m5k1woqizl1by/2018 Backlog.xlsx?dl=0

 

[RoryA]

Thanks. My laptop seems to have given up the ghost completely so I won’t be able to look at it until morning. Hopefully someone else may jump in in the meantime.