Charting and Blank Cells
Posted by Cindy on December 17, 2001 12:47 PM
I would like to create a chart that would chart, for example, A1:B30. A1 through B10 currently contains data. However, the rest of the range is blank. I would like to create the chart for the ENTIRE range but only view the data when that range become populated with data. I would add data every day of the month, but do not want to view blanks in my chart, nor do I want to recreate my chart every day when adding new data. Any ideas???
Have a great holiday if I don't hear from you by then.
Thanks in advance.