Bizarre diagonal lines 'joining up' data points.
When creating a bar chart in Excel 2007 and adding my own custom error bars, there appears to be a diagonal link between two data points. This doesn't happen to them all just the occasional one. How can I delete these pesky lines?
I'm using a Log 10 scale, as this is the only way to display the data bars correctly. When I switch to a normal scale, these diagonal lines disappear.
Any help would be really appreciated.Bizarre diagonal lines 'joining up' data points.