View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
jcollot jcollot is offline
external usenet poster
 
Posts: 1
Default Excel 2007 - Dynamic names for chart series

The dynamic names I used to utilize in Excel 2003 to define the data range
for charts in my worksheets don't work anymore, because excel modifies them
upon saving the file :

Filename.xls!DynamicNamedRange gets changed to [0]!DynamicNamedRange for all
the chart series using this syntax.

Is there another syntax I can use ? Any workaround ?