Error bars not displaying properly

A

AmberT

Hi,

I have plotted my data in a column graph, and added error bars based on
custom values. I know how to edit and format the error bars, but nothing I
have changed fixes my problem:

The error bars "join up" to give diagonal lines between between my columns.

I have NEVER had this issue in previous versions of Excel. If I plot the
error bars in pre-2007 excel, they're fine, until I open them in excel-2007.
If I remove the error bars, and plot them afresh in excel-2007, I get the
same problem.

It doesn't happen to every error bar, just some of them, for no apparent
reason.

How can I stop them doing this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Error Bars to Series and Colour 1
Working outlook via vba code with xlsx - error 0
No tab for error bars in Excel 2007 1
Odd chart type needed 1
Standard Error Formula 1
How do I plot a column average ? 1
Adding individual error bars 1
Plotting against Date (collating months) 2

Top