Excel 2003 has its "List", which for the purposes of a dynamic data range
(i.e., source data for a chart) works just like an Excel 2007 table. Select
the range, and press CTRL+L.
- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
## 2 Weeks Left! Don't Miss It!
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______
"Bernard Liengme" wrote in message
...
You need to explore the concept of 'dynamic chart'
Start he http://peltiertech.com/Excel/Charts/Dynamics.html
If you need more Google <excel dynamic chart'
If you have Excel 2007, it is every easy: just select the data used for
the chart and make it an Excel Table. The chart with expand/contract with
the Table. See http://www.microsoft.com/learning/en...oks/12284.aspx
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Bob" wrote in message
...
I have a list with names and values as follows:
A B
Law 22
Low 5
and so on for 34 rows. But the list can very in size. I have a chart that
takes the data from this list, but I can only have the source "1 to 34"
rows.
Is there a way that the chart veries with the size of the list?
--
Bob