I often copy an existing chart when I need one of the same type and formatting to save time.  Then I simply select the new dataset.  However, if I'm using custom error bars where I select the range of cells containing the errors, selecting the new set of error values doesn't seem to work.  If, after selecting the new error cells, I go back in to check the selection, the cells have reverted to the range on the original chart not the new range I selected.  It appears that one way to get around this is to remove the error bars by selecting "None" and recreating them from scratch.  Is this a known bug in Excel?

Hi

 

Thank you for using Microsoft Office for IT Professionals Forums.

 

Change the display of error bars

1. On a 2-D area, bar, column, line, xy (scatter), or bubble chart, click the error bars, the data point, or the data series that has the error bars that you want to change, or do the following to select them from a list of chart elements:
   

   a) Click anywhere in the chart.

   This displays the Chart Tools, adding the Design, Layout, andFormat tabs.

   b) On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want.
   
   

2. On the Layout tab, in the Analysis group, click Error Bars, and then click More Error Bar Options.
3. Under Display, click the error bar direction and end style that you want to use.

 

Please follow this link to Add, change, or remove error bars in a chart

http://office.microsoft.com/en-us/excel-help/add-change-or-remove-error-bars-in-a-chart-HP010342159.aspx?CTT=1

 

Please take your time to try the suggestions and let me know the results at your earliest convenience. If anything is unclear or if there is anything I can do for you, please feel free to let me know.

 

Best regards

William Zhou

--------------------------------------------------------------------------------

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I am having essentailly the same problem.  Even if i choose "none" under the error bar options, and then choose the "Cusom", and specific my upper and lower values, the error bars that are displayed appear to be UNRELATED to the data I supply??  I am a long time Excel user, and have never seen anything like this--seem like a bug, but hopefully I have just doing something wrong.

Thanks,

Michael

Hi william,

i kinda feel you missed the point to the original question here.

I too am having the same problem, as well as Michael below.

If you create a chart, add custom error bars etc, then copy and use that chart as a basis for a new one. When you try to change the source location for the error bars, it keeps reverting to the original location for the data. This is a bug. The only way to resolve it is to delete the errors bars, and re-add the error bars.

I am having same problem here.  I can remove the error by selecting none (under Layout/Error Bars), but I cannot add a custom values.  It seems obviously a big bug.  I have been using Excel for more than 15 years.

Anyone has ideas about fixing it?  I need to use it urgently.  Thanks