Bar chart question?

[Bob]

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?

 

[Bernard Liengme]

You need to explore the concept of 'dynamic chart'
Start here: 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/us/books/12284.aspx

best wishes

 

[Jon Peltier]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Bernard Liengme]

That I had forgotten. Thanks, Jon
--
Bernard

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Bob]

Thanks very much I shall look it up
--
Bob

That I had forgotten. Thanks, Jon