Chart not responding & rouge black vertical line

nighttrain20

New Member
Joined
Nov 18, 2006
Messages
15
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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

nighttrain20

New Member
Joined
Nov 18, 2006
Messages
15
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

New Member
Joined
Nov 18, 2006
Messages
15
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

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,103
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

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?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
37,103
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
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.
 

Forum statistics

Threads
1,136,340
Messages
5,675,202
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top