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. 

Question Info

Last updated February 21, 2018 Views 520 Applies to:

don't know why, but it seems as if the error has been fixed with the Security Update for Microsoft Office 2007 System (KB2553089):

someone confirm this?


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.