But data from ars ....Is there a way, I know it is, to make a diagram based on the visible rows when autofilter has been selected for some columns. Now I have the formula Average(A2:A120), if I activate autofilter, maybe only 22 rows are returned, so I want average to be calculated only for those 22 rows. With my formula now the diagram is not changed as the intervall is the same, in what way do I have to change the formula to only use visible rows?
I think someone has the answer. L ars Pettersson Vattenfall Business Services Nordic AB Action Request System Engineer (Tabasco) S-461 88 Trollhättan Sweden Phone +46 520 888 35 Mobil +46 70 608 99 95 e-mail: [EMAIL PROTECTED] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
