I want to exclude it from the chart without having to change the range of the chart. But the thing is, the chart adds the cells that doesn't have a value. Now, what I want to do is to select the range A2:A60 and insert that data to a chart. Same goes for the next row: =IF(Sheet1!E30 Sheet1!A3 '') Meaning, if cell E2 on the row I'm in is 0, then the copied value in the new spreadsheet is nothing. So I've got this formula in Sheet 2 in each cell from A2:A60 to M2:M60 which basically looks like this: =IF(Sheet1!E20 Sheet1!A2 '') So the data might change, meaning, some cells might be populated, while others won't. Now, this Excel sheet is updated dynamically via a macro that imports the data. I've got this Excel sheet which basically contains a lot of data.
