Vertical error bars only

  • Thread starter Thread starter Richard
  • Start date Start date
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
 
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
How do I add a vertical line to a horizontal bar chart? 3
excel 2000 1
Vertical Highlighting on line graph??? 1
Creating a Combination Bar Chart with 2 Lines 1

Back
Top