troubleshooting Question

Excel 2010: Drop-down Lists Not Populating in Charts

Avatar of itsmevic
itsmevicFlag for United States of America asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
16 Comments1 Solution434 ViewsLast Modified:
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.)

The problem...

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.
Cost Accountant
Join our community to see this answer!
Unlock 1 Answer and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros