Graphing: Show zero values but omit values that are blank in the chart

It will depend on chart type, I expect. Here's a good starting place: https://peltiertech.com/mind-the-gap...g-empty-cells/

Change the source data to distinguish between 0 and blank cells - maybe change formulae to return N/A instead of blank?

Attach the workbook - let's have a look at what's going on.

As explained in Peltier's link, the "best" approach for column/bar charts is to

Originally Posted by Jon Peltier

For these chart types it would be better to use “” or even zero, and apply a custom number format that suppresses the display of zeros (a format like “0;-0;;”).

. The problem in your example is that you have real 0 values in addition to empty values, and this approach will not distinguish between "real 0 value" and "0 that is a text string empty cell placeholder". Do you need to be able to handle those 0 values, or are they just placeholders where 0 is not really an expected result? If 0 is not an expected result, then that might be a good place to start.

If you must be able to handle real 0 values, this might be a case like he describes:

Originally Posted by Jon Peltier

Alternatively you could rely on VBA to clear cells which need to be cleared, but this routine would have to run every time the data range is changed, and it would have to reintroduce formulas into previously cleared cells as well as clear cells where blanks are needed. Or it could do all of the calculations in VBA, eliminating the worksheet formulas.

Or perhaps this is a case where you think through what you are doing and do something completely different.

It occurred to me after the previous post that the columns Y:AB might populate from top to bottom, where the blank cells you need the chart to ignore are always at the "bottom" of the range. If this is the case, then a "dynamic named range" for the axis series might be a suitable approach http://www.criticaltosuccess.com/dyn...-named-ranges/