ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I do individual error bars for bar graphs? (https://www.excelbanter.com/charts-charting-excel/141569-how-do-i-do-individual-error-bars-bar-graphs.html)

Slyther

How do I do individual error bars for bar graphs?
 
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?

Del Cotter

How do I do individual error bars for bar graphs?
 
On Fri, 4 May 2007, in microsoft.public.excel.charting,
Slyther 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 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.

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


All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com