Pie Chart help please

[MadHatsJess]

Hello,

I have a drop down list that populates a table using a Vlookup.

My table has a possible 10 rows.

I need to be able to use the drop down and the pie chart reflects the table.

The problem I have is that I have selected 10 rows but if the data only fills half then the pie chart doesn't work.

I would be extremely grateful if someone could help



[TABLE="width: 307"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]