ommitting empty cell from chart

**douglukas** · 02-05-2008, 10:06 AM

I have a chart that spans 30 cells. Each cell is used for entering daily data, (i.e.- cell 1 is for jan 1, cell 2 is jan 2, etc...).

I want to view only days that have data entered into the cell. Example: today is Feb 6, so i have only data from feb 1 through feb 6. How do I view only those 6 days and once I enter data for feb 7 have the data automatically populate chart once data is entered into the cell for the next day?

Any help would be greatly appreciated.

Doug

**oldchippy** · 02-05-2008, 12:52 PM

Hi,

Does this previous post help, by using #N/A for zero values?

http://www.excelforum.com/excel-charting/631914-chart-connect-data-points-with-line-for-hidden-and-empty-cells.html

**ChemistB** · 02-05-2008, 03:15 PM

You could also look at defined names of dynamic ranges. They expand as your data expands but work best with sequential data, (no blanks in between).

ChemistB