I have three sheets with two columns each. I want a chart that compares the data from these sheets. the only way I can get it to work is by combining all the data from the three sheets onto a new sheet. That is fine but what happens when I get lots and lots of worksheets? Is there a better way to do this?