View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default line series order Excel 2007

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?