That depends… is there a certain set of criteria that you’re using t
determine whether or not a certain cell is included? You may be bette
off mirroring the same data contiguously in a hidden row, column o
sheet and pointing the chart at THAT data. - Piku

--
Message posted from http://www.ExcelForum.com