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?
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?