Re: How do I do individual error bars for bar graphs?

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Fri, 4 May 2007, in microsoft.public.excel.charting,
Slyther <Slyther@xxxxxxxxxxxxxxxxxxxxxxxxx> said:

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 spread***, 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 spread***.

--
Del Cotter
NB Personal replies to this post will send email to del@xxxxxxxxxxxxxxxxxx,
which goes to a spam folder-- please send your email to del3 instead.
.

Quantcast