Updating links between excel and powerpoint
Despite all the assurances that context menus work the same in Excel 2007 as in earlier versions, you cannot add an item to an Excel 2007 chart-related context menu.
What I’ve done instead is to add an Error Bars item to the end of each of the three Chart Tools contextual ribbon tabs.
Finally, select the More Error Bars Options at the bottom of the list.
Install this utility by following the instructions in Installing an Excel Add-In or in Installing an Add-In in Excel 2007.In the chart below I have clicked once, which selects both X and Y error bars in an XY chart. Any changes you make on the Patterns tab affects both X and Y error bars.The other two tabs allow you to reapply error bar values.Microsoft has made a number of changes to how you use error bars in Excel 2007.I wrote an article some time ago, which covered how to use Error Bars in Excel Charts, for versions 97 through 2003. It’s easy to add error bars in Excel 97 through 2003.