eliminating empty cells from chart area

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

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" <[email protected]> wrote in message
news:[email protected]...
>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