Dont want zero data showing in bar chart

Using columns B:E as the example , I have totals in column E from E4:E12
This is shown on the bar chart `Gas` although cells E13:E19 do contain a formula they remain blank until the data is added.

Due to E13:E19 containing a formula this is shown on the bar chart.

Is it possible to not having anything showing in the bar chart for E13:E19 until data is added in column D.

Example attached.

I don't think your existing formula for the gas total in E4, i.e.:

=AA4+AB4-AC4+(5%)

is correct. This will always add the value of 5% (i.e. the numerical value 0.05) onto the costs, so it will add 5p to those costs. I think you should have:

=(AA4+AB4-AC4)*105%

You can ensure that no values are shown on the chart by changing the formula in E4 to this:

=IF(Y4=0,NA(),(AA4+AB4-AC4)*105%)

and copying that down. You will see #N/A in the cells from E13 onwards, but you can hide those by applying conditional formatting to the cells (use white foreground if the cell contains an error).

Hope this helps.

Pete

Thanks for the correction, and the formula for the bar chart works good.

thank you

You're welcome - thanks for the rep.

Pete