Is there a way to give range names (especially with relative reference) for series names and series values in Excel 2007 graphs?
 

Is there a way to give range names (especially with relative
reference) for series names and series values in Excel 2007 graphs?
Actually this method is possible in up to Excel 2003 to make changing
graphs based on Active Cell. I totaly failed to apply the same in
Excel 2007