SUM(B2:B11) You might prefer to use Excel's built-in Total Row function to force Excel to calculate the total automatically. You will then see the total appear as a new column in your chart.