Dynamic Chart with array data
Hi everyone, I am kinda stuck with this excel issue. I have a list of items throughout the duration of 52 weeks... these items show the number of data for each. Question: 1) How can I have a dynamic chart where I can display the items based on my selection of the week from a drop down list. 2) Only show the items that show values above zero. Note that my data is an array and not a single column. I don't want to use pivots or separate sheets for the formulas and definitely no coding. I would like to keep my sheet simple and clean by embedding the formulas within the chart itself. Thanks