Here's our Microsoft Office Tip for.. May 22, 2000
Click Here to see a complete list of all of our previously released Tips!
Uncovering the Values
Each series in any Excel chart represents a value. However, the chart doesn't always display that value--instead, you must glean the value from the axis values. If you'd like to know the value of any given element in a chart, simply point to that element. Excel will soon display the element's series name and underlying value.
You can turn this feature off if you want (or turn it back on) by choosing Tools, Options; clicking the Chart tab; and selecting the Show Values option in the Show Tips section to display the element's value. The Show Names option shows the series name. By default, they are both turned on. You can choose both, neither, or one or the other.