Hello,
Does anyone have a magic trick for my very specific issue?
I am using an offset formula for a set of graphs - looking at the last 28 entries some of which include 0%'s but they look rubbish on the graph so I'd rather it show gaps in the graph.. However, when I put an If formula in to my table to show " " or N/A the graph doesn't like it and presents no data because the offset gets confused.
The offset I have applied in a defined name for the graph to pull from..
=OFFSET('LE1 - Table'!$D$1,COUNT('LE1 - Table'!$D:$D),0,-28,1)
The Hlookup I have to pull the data I need in to a table I can work with..
=HLOOKUP([@Date],'Data Input'!$1:$1048576,45,0)
In the Hlookup i've tried the IF 0%," " but as I mention above, it messes with the offset.
Any help would be great!
