I'd like to NOT show zero values on a chart and despite some good information
via this site (ie ToolsOptionsChart the "plot empty cells" GUI is
disabled), I think I may need another method via VBA, so....

I have a range named "ChartData" and it refers to the populated cells a1:b7.

What I need to do is, if cells a5:b7 are blank, systematically redefine the
"ChartData" range to then refer to a1:b4. (via sorting the range, I can
ensure all the blank data is at the bottom of the ranges).

If this can be accomplished, then the chart data range will only have data
and my issue with NOT showing zero values will be resolved.

If anyone can either provide the code to accomplish this or suggest a more
efficient alternative, please help.

Any and All Help Will Be Appreciated - Thanks In Advance