Here's one way. Assuming your items are in col. A and
values in col. B, starting in A1, place this in B1, press
ctrl + shift + enter, and fill down as far as needed:

=INDEX(OFFSET($B$1,,,COUNT(B:B)),SMALL(IF(OFFSET
($B$1,,,COUNT(B:B))<0,ROW(OFFSET($B$1,,,COUNT(B:B )))),ROW
()))

Change your source range col. B, but use a dynamic range.
Define a name and use the formula:

=OFFSET(C1,,,COUNT(C:C))

To learn more about using dynamic ranges in charts, see:

http://www.peltiertech.com/Excel/Cha...micColumnChart
1.html

If your data does not start in row 1, let me know and
I'll adjust the formula.

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi

I currently have some data as shown below:

Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9

How can I exclude the zero items automatically, the data
shown below is
going to change regulary and i do not want to have to
keep change the source
data manually.

D


.