For Excel 2003 and earlier: Select the chart, go to Tools > Options > Chart
tab, check the box for “Plot Visible Cells Only”.
-
Pages
-
Categories
-
Archives
Category Archives: Answers
How not to include hidden cells in MS Excel graph
April 24, 2008 – 5:07 pm