Here we have a simple table with meals and nutrients of those meals in grams. Lets say we want show proportion of those nutrients using Pie Chart.
Very good feature to have in MS Excel is a dynamic drop down list when it is possible to add additional options to drop down with less efforts. So how to do it.
First of all lets make a source which will feed our drop down list. I decided to have some fruits in my drop down list.