Help with building a dynamic table and chart

Can someone help me with building a dynamic chart and table? I have attached a sample worksheet.

If you look at the first worksheet I have a listbox that runs a macro that feeds the selected values into the table on the right starting at I13. The columns J & K in the table are fed via a vlookup pulling data from the second worksheet.

My qustion is how do I make the table on the first worksheet dynamic, so that when there is nothing selected it reverts to just one line and the same happens with the graph. Because if you look now it shows 0 values for 5 criteria.

Any help would be greatly appreciated.

Originally Posted by dilipandey

Hi thelegazy,



which one line you want to show when nothing is selected ?



Regards,
DILIPandey
<click on below * if this helps>

Dilipandey,

I've uploaded an uploaded file.

If you select a, b, & c from the list box on the left you will see the graph and table on the right adjust (which is great), but if you go to deselect b & c you will see that the graph is still spaced out for three items rather than two. Same goes for the table.

Is there anyway to fix it so that when you deselect the other two the graph will automatically adjust to the one selection?

Bump, can anyone help me with this?

Originally Posted by thelegazy

Bump, can anyone help me with this?

NVM, this thread helped me if anyone needs it: http://www.excelforum.com/excel-prog...ive-sheet.html