00:00If you want to learn how to highlight a bar chart like this, stay tuned. I'm going to show you
00:03exactly how this is done. The first thing you have to do is to introduce a new column. Let's call
00:08this column a selection column here. And the formula in that is equal to if open parenthesis
00:12this country is equal to the pulldown country. I'm going to press F4 to make it fix. If they are
00:18equal, I'm going to show population. If they are not, I'm going to show blank like this and hit
00:22enter. And I'm going to apply the same formula to the rest of the row like this. Now, if you make
00:26changes to the country here like this, you can see that the adjacent selection column
00:31get populated. Next, you'll be selecting the bar chart like this. And after that, drag the
00:35blue box into your selection column, right click the new bar chart, format data series,
00:40and the overlap, you're going to put it to 100% and close this. And to put the cherry on
00:45top of the icing, select your selection column here and basically change the font color to
00:50white so that it's not visible. Now, if you test your pulldown menu, the bar chart are
00:54being highlighted accordingly.
Comments