ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   #N/A (https://www.excelbanter.com/charts-charting-excel/87118-n.html)

Arturo
#N/A
 
Surprising Zeros in Charts

My model is built.
Using #N/A - my chart displays perfectly, zeros suppressed.
This formula is what feeds the values in my chart series.
=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),€¯€¯,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))

If I alter that error handling
to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),"#N/A",((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
Zero still displays€¦
If I may ask €“ how would I alter this formula to function they way I hope it
would?

Sincerely,
Arturo

Arturo
#N/A
 

=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),#N/A,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))


"Arturo" wrote:

Surprising Zeros in Charts

My model is built.
Using #N/A - my chart displays perfectly, zeros suppressed.
This formula is what feeds the values in my chart series.
=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),€¯€¯,((AVERAGE(SHEET1!BE2:BM2))*(100/5)))

If I alter that error handling
to:=IF(ISERROR(((AVERAGE(SHEET1!BE2:BM2))*(100/5))),"#N/A",((AVERAGE(SHEET1!BE2:BM2))*(100/5)))
Zero still displays€¦
If I may ask €“ how would I alter this formula to function they way I hope it
would?

Sincerely,
Arturo


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com