How to Create a Dynamic Chart Range in Excel

[@dpb1997]

HI, this is great video. Thanks for making it. I am having an problem with this - =IFERROR(MATCH(B2,Order_ID,0)+3,""). It will not return 4. The next formular does not work either. I suspect it is to do with the Orders DB sheet. I have formated as a table. Any ideas? Thx

[@inerasmodellfornyttokalkyl1201]

I followed this step by step but Im not getting the charts dynamic. If I change the data, the array picks up on the change but not the chart.

[@manor169trekker6]

Thanks a lot

[@Swegma]

THANKS YOU SO MUCH

[@princesslondon4842]

What if one of the categories is zero? Can you dynamically remove the category and value from the chart?

[@inerasmodellfornyttokalkyl1201]

WOW!

[@cmlosaria]

I want to not show on the chart a categorical row with value of zero. is that possible?