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.
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.