How to Create a Dynamic Chart Range in Excel 

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.

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

THANKS YOU SO MUCH

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

Thanks a lot

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

WOW!