A wizard would sure be convenient, but I wouldn't count on seeing it in
Excel any time soon. If your dynamic range only needs to expand and contract
as data is added or removed from a range, you can convert the range to a
List (Excel 2003: Data menu, List... or Excel 2007, not sure the tab, but
convert to Table). As the List/Table resizes, any formulas, including chart
series formulas, automatically change the reference to all of the rows in
Otherwise, you need to specify the worksheet or workbook containing the
Name, otherwise the chart will not be assured of finding it correctly. You
have to use the worksheet name when assigning a regular range address, and
doing so for a Name is really no different.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Feejo" <Feejo@discussions.microsoft.com> wrote in message
> Creating a dynamic chart is difficult, there should be a dynamic chart
> that will create it with you.
> Also if my serie value is a name range, it would be nice to just right the
> Name range directly not with the complex formula.
> ='xyz.xlsx'!name range
> but just name range.
> xyz and name range is a fictive value.
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.