![]() |
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? |
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