Excel 2007 - Dynamic names for chart series

J

jcollot

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

Dynamic charts with named range Windows 8.1 0
Chart SERIES OFFSET 5
Excel 2003 dynamic named range for the values in a pie chart 1
One extra x axis item that wont go away - can anyone help? 3
Dynamic charts with named range Windows 8.1 3
Copying Named Ranges in Chart Series 1
Dynamic Stock Chart 11
Can you input multiple series names and values with a single definedname ? 0

Top