Hello,
I'm having an issue that I believe the most difficult part is asking the question. So I'm going to try to do pictures. However as a quick rundown, I have 4 tables. General structure of tables is:
So there are 4 separate rows setup like that. Each Cell is linked to an external workbook. Each data set in the table is linked to a different external source (This is because each company has their own report). Then there is a 5th sheet that tracks a total of the 4 sheets. The current formula is as follows: =IFERROR(IF(SUM(B$9+B$20+B$29+B$36)<>"",(B$9+B$20+B$29+B$36),""),"") which looks great in the table. But if you look at the chart below it is being plotted on zero. How can I make that dynamic and not plot zero? I think it's probably in the formula because so far I have tried going to select data and hide zero's/blanks, I've done that setting in the options>advanced>display>don't show zero's. Not having any luck. Anybody have better ideas?
Thank you in advance for any of your help!
I'm having an issue that I believe the most difficult part is asking the question. So I'm going to try to do pictures. However as a quick rundown, I have 4 tables. General structure of tables is:
January | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total | |
2022 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - | $ - |
So there are 4 separate rows setup like that. Each Cell is linked to an external workbook. Each data set in the table is linked to a different external source (This is because each company has their own report). Then there is a 5th sheet that tracks a total of the 4 sheets. The current formula is as follows: =IFERROR(IF(SUM(B$9+B$20+B$29+B$36)<>"",(B$9+B$20+B$29+B$36),""),"") which looks great in the table. But if you look at the chart below it is being plotted on zero. How can I make that dynamic and not plot zero? I think it's probably in the formula because so far I have tried going to select data and hide zero's/blanks, I've done that setting in the options>advanced>display>don't show zero's. Not having any luck. Anybody have better ideas?
Thank you in advance for any of your help!