Excel 2007 - Dynamic names for chart series

G

Guest

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 ?
 
B

Bernard Liengme

If the data is in a Table (new XL2007 feature); the chart is automatically
dynamic
best wishes
 
G

goofy11

Supposedly SP1 takes care of this bug.

Bernard Liengme said:
If the data is in a Table (new XL2007 feature); the chart is automatically
dynamic
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

jcollot said:
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 ?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 3
Dynamic Stock Chart 11
Named data series won't dispay in Excel 2007 4
Dynamic Chart with Defined names 4
Calendar Control and Dynamic Chart 1
Is this bug in Excel 2007 charts? 5
XY scatter plot with more than 32000 rows in Excel 2003 0
Dynamic stacked bar chart not working 3

Top