Hi all,

I have been doing this for many years and now being under a time crunch I need some help. I draw maps with the charts and then draw precision calculated lines on them. Every time the company forces us to upgrade to the latest version I have to make a bunch of fixes as I am sure you guys do too. Well, on this last one which is a unique map for my project the lines I was calculating were showing up as a single horizontal line. Mind you some of the lines are plotting as many as 49,000 points. I played around with it and found that this phantom line disappeared when I just plotted rows 2 through 72. Once I added that row 73 it went to the horizontal line. I have one set that has 13,000 points and it is displaying correctly. I am looking everywhere for what the difference is then I noticed in the Select Data Source window that for the Horizontal(Category) Axis Labels every series is rounded up to "6" which is just a tad bigger than my right axis. But on the troubling series all of the numbers are precisely what is in the cells. I can't figure out what is driving that. I have tried recreating the columns and it doesn't help. I seem to remember developing this particular chart in 2007 version which I don't have access to but I went back to 2003 and the problem persists. BTW I am only working in the primary axis. Any suggestions would be greatly appreciated.
Excel Select Data Source2.JPG