I have a chart that shows performance each week for a year. Its source is from a spreadsheet that has formulas in it referring to each week. The problem is that the chart drops and reflects zero values for the weeks that don't have data yet. (the remainder of the year). The Tools, Options, Chart, Plot Empty Cells option does not work since the cells are not empty, but instead have a formula in them. Any suggestions on how to plot only the cells with data in them? Thanks.