New complicated twist on zero values and bar charts

Hey guys, I have been working on a research project for a few weeks which requires some off-label use of charting and formulas. I've been lurking the crap out of your forum which helped me come up with this monster

Please Login or Register  to view this content.

(trust me, it was all necessary....) So thanks already for helping me get this far into my project.

The issue I am having now, is I want to do something similar to what they do on this website

http://peltiertech.com/WordPress/bro...n-excel-chart/

(p.s it's only quoted because It appears that quotes don't show up for lurkers and I am not sure how strict you guys are about linking external sources. So... noob trying to avoid making problems)

But in doing the above, I only want the 2nd axis to only show data in ranges 200-450 (so, basically creating a break, even though that site says it is best to show everything). When I attempt this, all of the previous fields which have "0" values, now show up all across the bottom of the graph. I have no idea why this is happening as I would think they would simply be excluded. But they aren't. I need the 0 values in the chart to maintain spatial relationships between individual bars. Any ideas? I feel like this should be easy but it is getting frustrating.

Thanks in advance.

FYI, sample data

X axis Y Axis (series)
1 0
2 0
3 200
4 0
... 0
... 0
... 0
600 0

Making 2 lines of data matching the above should give a giant graph with only 1 bar at x=3, y=200. If it starts out screwy after adding the Y in as the series I just went in and edited X values and selected the appropriate range.

Now, if you change the Y axis range from 0-250 (or whatever it auto decides) to 175-225 (i.e. zooming in on the top of the high range) suddenly every 0 value appears at the bottom.

Added notes, I am using border options to thicken data points. I don't care if they run together. I guess I haven't tried it yet without to see if it is an issue with borders or with the data in general.

I had considered that, but the data is owned by the lab and I suspect it wouldn't be appreciated if I posted it online. I can make up a simple list quick to mimic what I am talking about. I guess I was hoping that this was a common enough limitation that someone would know what I was talking about.

It's basically like this. It does appear to be an issue with using borders, because they don't show up without.
So the problem is, I need something like that first graph to display where the lines are thick enough to see easily but where it keeps spatial relationships intact. I can't figure out a way to get excel to allow bar graphs to run points into each other, so I am making thick borders as a workaround. It messes up the height a little, but for what I am doing it is actually more important to see the gaps than it is to see the individual data points.