If the filled cells are at the top, and the empty ones at the bottom, you
use an offset statement which includes COUNT to determine the length of the
named range. If you have prepopulated the category labels, use only the
column of data values to determine the length of both ranges. Change
Bernard's definition of Date to the following, so the two ranges are the
same size):

=OFFSET(Sales,0,-1)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"cooter24" wrote in
message ...

Thank you I believe I have seen your post. I know how to set up the
named range what I can't figure out is how to get the chart to only
plot the cells that have values and ignore the ones that are blank.

Thanks


--
cooter24