Excel charts not updating dating mail addreses
You can enter another constant value, and you don’t need to type the equals sign or curly brackets; Excel will insert them. Make sure you delete the entire contents of the entry box before selecting a range, or at least select it all, or Excel will think you meant to enter something like If you want the value to be zero, enter zero. because Excel will think you simply forgot and it will retain the previous value.
For all of the problems, using error bars in Excel 2007 isn’t completely terrible.
I don’t remember if this is the most useful, or the only useful, new formatting feature available in Excel 2007 charts.
From this dialog you can assign values to the error bars, such as a fixed value, a percentage of the data point value, a couple of statistical measures, and custom values from a worksheet range.