Hi
I have a dynamic range defined (as per instructions from this website - cheers :-)). I have a problem however, when the range inclues some totally empty cells. If the data has not been logged by another piece of software, then the excel sheet will have empty cells in some protions of the column.
So, I am using the COUNTA() function with OFFSET() to define a range. Works fine until there is empty cells. At that point the chart displays an error when trying to show the data. Now, I have used another guy's solution by putting #N/A in the cells. This results in data being plotted, but the #N/A point is ignored.
What I really need is to somehow show on the chart line any unrecorded sections - for instance, by changing the line from solid to dotted. Any ideas?
Many thanks, sorry for the waffle.
Start Free Trial
