Hi everyone,

I'm having some difficulties with some VBA coding. The situation is as follows:

I have a number of drop down lists which enable me to calculate ratios. By selecting a certain Name from the drop down list, ratios are automatically calculated. These choices sort of enable you to create a universe to illustrate the comparisons. This data is then reported onto graphs/charts.

At the moment all 10 of the drop down menus have content in them, but i'd like there to be the option of choosing nothing, and when that choice is made the graphs resize themselves to only show the data from the various choices made in the drop down lists. The problem I currently have is the fact that when I choose 'Nothing' the graphs doesn't resize itself and just shows 0 figures.

To explain better here is an example:

From the dropdown list you can choose the name of a football player. By choosing a certain name you get all of his statistics (goals scores, minutes played, assists...) from this year and the previous year. The concept of the universe enables me to compare one player to another, in other words, to see what % of goals have been scored by a specific player in comparison to the other players selected. E.g. If you choose only 2 players and one has scored 7 goals and the other 3 then the first player will have score 70% and the other 30%. But if you choose a third player and he has scored 13 goals then you'll see that the first player has score 35% of goals, the second 15% and the third 50%.
This in turn would be illustrated in a graph whereby in the first situation you would only have two players illustrated in the graph but in the second case you would have three. I don't have any issues to solve this when I try to do Pie charts but if its a Bar graph the drop down list where 'nothing' is chosen shows a blank space where there would have been a chart had Player been chosen in the drop down menu.

Does anyone know if there is a VBA code which could help me with this issue?