Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y error bars
Can anyone tell me if there is a way to adjust the width of the horizontal
portion of the y error bar. I want it to be the same width as the bars on my bar chart. Thanks John |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y error bars
Technically you are limited to what you can do with error bars. You can work
around these limitations but its quite a chore. For example, create two additional series one with a value of the lower error bar, the other with a value of the amount the upper error bar extends beyond the lower. Add these two series to the chart. One at a time change their axis to the Secondary axis. Then change their type to Stacked column. Then change the color of the lower series to none along with the border for that series. You may need to also change the series order to get the error bars in front of the data. -- Cheers, Shane Devenshire "JRD" wrote: Can anyone tell me if there is a way to adjust the width of the horizontal portion of the y error bar. I want it to be the same width as the bars on my bar chart. Thanks John |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y error bars
Hi Again,
One other solution - get Excel 2007 - it allows you to control the width of the error bars. -- Cheers, Shane Devenshire "JRD" wrote: Can anyone tell me if there is a way to adjust the width of the horizontal portion of the y error bar. I want it to be the same width as the bars on my bar chart. Thanks John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error bars | Charts and Charting in Excel | |||
x or y error bars? where are they? | Charts and Charting in Excel | |||
Error bars in VBA | Charts and Charting in Excel | |||
Error Bars | Charts and Charting in Excel | |||
y error bars | Charts and Charting in Excel |