Make a dynamic chart, which is based on a range which only includes
non-blank cells:

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

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



"financeman500" wrote in message
...
I have a range of 21 cells that are tracked for values on another spread
sheet at different times not all of the cells will have values this
changes
daily. I only want to chart the cells that have a value in that cell range
but my charts keep showing the empty cells, any suggestions would be
greatly
appreciated