Posted by Johnna Hogue on January 10, 2002 1:12 PM
I am trying to create a line chart using information that is calculated by a formula. I want to set up the chart so it will show Jan - Dec of the given year and only plot the data that has been calculated - ignoring the cells that have no data in them. I have set up "IF" statements in the cells that calculate telling it to do the calculation if data has been entered in another cell, if not, it puts a " " (blank) in the cell.
Unfortunately, Excel reads the blank as a zero and plots this on the chart.
Is there a way to tell the chart to treat blanks as no data and not plot anything?
I don't want people updating the information on the spreadsheet to have to update the charts.