Hi all,

I want to use the offset function in a named range to be the data source for a column of sparklines, I want the sparkline to grow incrementally as data is updated per month.

The data in the table I want to add sparkline to is pre-calculated with SUMIFS formulae, and updated monthly from a dump of detailed data. I am trying to automate this as much as possible, and have pre-calculated future performance data in the table. I used an IFERROR to return a hyphen for the future reporting months.

The problem is, the sparkline is reading the hyphen as zero value, and the sparkline is showing as if it was reporting data to the end of the reporting period.

So my question is - is there a better IFERROR option that wouldn't be read as data, or is there a way to define the range by date compared to a data date?

Thanks in advance,
Ruth