View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Change Names of Legend

Select the series, and look in the formula bar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Taylor" wrote in message
...

'Not sure how you got your formula data, this may be the hard way, but
I write in my VBA debugging window (with the chart selected):
debug.Print activechart.SeriesCollection(1).FormulaLocal
(is this how you got yours?)