I have a dropdown which has these options - Group Total, Group Breakup, Member1, Member2, Member3. As you select options in the dropdown, the corresponding data will change. This works fine. Now, my problem begins here. I also have some charts which will change based on the data that is there. If i select group total, only 1 chart showing the values should be seen on the page. If i select group breakup, then i want individual charts to appear for each member in the group. If i select member1, then only 1 chart should appear showing member1's values. How can i do this without VBA? Please help. This is urgent.