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