Wednesday, 23 May 2007

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.

No comments:

Analytics and Statistic

Blog Archive