How do I do individual error bars for bar graphs?

S

Slyther

I'm stuck, I can't seem to be able to get excel to put in individual values
for my error bar I want to put on my bar graph. How do I rectify this?
 
D

Del Cotter

I'm stuck, I can't seem to be able to get excel to put in individual values
for my error bar I want to put on my bar graph. How do I rectify this?

What is it that you're doing to try to achieve this? You can't select a
bar and choose a value in the error bar tab; that will always affect all
the bars in the series, even if you only selected one bar.

The facility that lets you alter the values by bar is the "range" at the
bottom of the dialogue box. Enter your values in the spreadsheet, and
then in the error bar dialogue tab select the range containing the
values. All the bars will then have different error values, depending
on what you've entered in the spreadsheet.
 

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

Top