Vertical error bars only

R

Richard

Hi

I have several line and scatter graphs where I want to add vertical error
bars ONLY. Every time I try to do this, horizontal error bars appear as
well. Is there a way of only inputting vertical error bars? I don't want to
have to delete the horizontal ones every time as this will take up time.

Cheers
 
A

Andy Pope

Hi,

Assume you are referring to xl2007.
Looks like both are applied with no UI to choose which to apply.

You could use code to add error bars if manual deletion is too time
consuming.

Cheers
Andy
 

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

removing horizontal error bars in excel 2007 chart 4
Adding only vertical error bars to a single data point in a series 5
vertical vs horizontal error bars excel 2007 1
Error bars in scatter plots 2
formatting DATA bars 1
Convert Error Bars to Series and Colour 1
error bars don't display consistently in excel 2
Creating a Combination Bar Chart with 2 Lines 1

Top