As the Title says, my drop-down lists are not populating into my charts.
I have five worksheets, in my work book. A Summary, High, Med, Low and Enter Keyword worksheets that comprise my entire workbook. My worksheets i.e. High, Medium and Low all have drop down lists. My last worksheet enables the user to enter in "keywords into a Hidden worksheet that acts as sort of a database if you will of these keywords. The whole purpose of this is so the user add their own keywords to the drop-list for the High, Medium and Low worksheets (It populates those worksheets simultaneously with the new keyword in the drop-down list.)
I noticed on my Summary worksheet which is nothing more than my Dashboard that contains several charts based off of the data in the three worksheets (High, Med and Low)that some of the categories (keywords) are not populating like they should in my charts on my Summary page. They will only partially populate and I can figure out why. I have to keep deleting the charts and the worksheet assigned to that chart and rebuilding the chart and worksheet in order for it to capture the items I'd like it to capture in the drop-down list. I'm curious as to why the charts aren't reflecting some of the keywords in the drop-down list? Any help is GREAT APPRECIATED as I've been trying to work this delima for days now with no resolve.