I am trying to create a dynamic chart using a list box. I want the Week Selected from the List box displayed on Cell E4 and the corresponding values for the selected week populated. My Data is on Sheet titled “Data” and my Dynamic Chart on the second sheet. So the Chart changes based on the Weekly Data.
Please find attached the document for better clarifications, i will appreciate any help/ clarifications on how this can be achieved from this forum.