This is true if you use a named range in the Data Range tab of the Source
Data dialog. Excel does not remember these names, but instead always
converts them to the cell addresses of the names.
If you use named ranges for the X and Y value ranges of each series, in the
Series tab of the Source Data dialog, the names are remembered.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Jennifer" wrote in message
...
Have you guys noticed that when the named range changes in size that the
chart kicks out the name and reverts back to the original selection size.
Example
Table is originally A1:B10
You name it
Create a chart and it accepts the named range
BUT
Table grows and now it is A1:B15
It kicks out the name and in the source it says Sheet1!A1:B10
What is that about?
--
Thank you,
Jennifer
"ShaneDevenshire" wrote:
Hi Rob,
Since time began we have used dynamic range names to handle this problem,
however, as of 2003 there is an alternative which works if you data is in
columns as your's appears to be.
Suppose the data is in the range A1:B200. Highlight the range and choose
Data, List, Create List, OK. (in 2007 lists are called tables)
Now create your chart from the list range. If you add new rows of data
the
chart will automatically include them as long as they are directly
adjacent
to the list (below). And if you delete any rows of data in the list, it
will
also adjust. There are some differences between this approach and the
dynamic range name approach, but if this does what you need it is easier
to
set up.
--
Thanks,
Shane Devenshire
"Rob" wrote:
I'm looking for a Dynamic means of populating a bar chart.
Cloumn A (Rows 2-200) Has the Names (Y Axis) of each Item and Cloumn B
(Rows
2-200) (X Axis) has the Number Values. My problem is twofold... One,
every
week the Y axis list can grow or shrink and Two, I only want to show
those
that have an X Axis value that is greater than five. Anything less than
or
equal to five I would like to have hidden from showing in the chart.
Is it possible to have some sort of way or formula that can make this
possible in a chart or in pivot table?
Thanks in Advance.