Hi guys, new to the site so let me know if I'm doing anything wrong and I'll improve!
So I have a large chart of data with tens of thousands of cells. My task is to create a tool that will create a dynamic and interactive column chart that is linked to either drop down boxes or a search bar. These should be able to filter the data by several different fields and preferably be able to select more than one option in each criteria.
I have tried several approaches to this including using Excel VBA, slicers and combining data validation boxes with the VLOOKUP function however I have run into problems with each one.
I understand how to do this using pivot charts however the project requires me to do it without.
Any pointer in the right direction as to what technique is best would be much appreciated. I am using Excel 2010.
Thanks so much!
So I have a large chart of data with tens of thousands of cells. My task is to create a tool that will create a dynamic and interactive column chart that is linked to either drop down boxes or a search bar. These should be able to filter the data by several different fields and preferably be able to select more than one option in each criteria.
I have tried several approaches to this including using Excel VBA, slicers and combining data validation boxes with the VLOOKUP function however I have run into problems with each one.
I understand how to do this using pivot charts however the project requires me to do it without.
Any pointer in the right direction as to what technique is best would be much appreciated. I am using Excel 2010.
Thanks so much!
