If you have actually selected a series, its formula will appear in the
formula bar. If you've clicked on something else, like a data label, there
will be no series formula. In the Name box (Excel 2003 & earlier) or in the
top left of the two rightmost chart tools tabs, the name of the selected
chart element will be displayed, so you can tell if you have not selected a
series.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"rolando" wrote in message
...
I have charts with over 5 series.
I mostly reorder them by selecting the series and update the ordernumber
in
the formula of the series displayed in the formula bar, but ...
the selected series is very often NOT showed in the formula bar , why is
that?