High/Low Markings - Bar Chart

[calumll]

Hi,

Would someone be able to tell me if it is possible to add high/low markings in a bar chart. I've tried adding error bars, however it gives one value for the whole series. Do I have to separate each data set into individual series?

Example... (where I have put into separate series)
- The bar chart represents the average value
- The 'error bars' mark the highest and lowest points

347a252.jpg

Many Thanks

[Andy Pope]

See recent thread on the subject of custom error bars
http://www.excelforum.com/excel-gene...rror-bars.html

[calumll]

Thanks... but that method sets the error bar value for the whole series. I need a method (if there is one) to set the error bar for each bar.

[Andy Pope]

Did you check the attached file with the screen shot of the Error bar dialog with the custom values set??

Post your example file