Bar chart question?
 

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

Bar chart question?
 

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

Bar chart question?
 

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

Bar chart question?
 

That I had forgotten. Thanks, Jon
--
Bernard

"Jon Peltier" wrote in message
...
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

Bar chart question?
 

Thanks very much I shall look it up
--
Bob


"Bernard Liengme" wrote:

That I had forgotten. Thanks, Jon
--
Bernard

"Jon Peltier" wrote in message
...
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