In the comments of Choice of Category Axis Order a reader asked how to use only part of a range as the source data for a chart. Her data and chart initially looked like this:

The line “Total Other Items” is a sum of the items below it in the list, and the chart does not show this subtotal. The series formula looks like:

=SERIES(Sheet1!$B$1,(Sheet1!$A$2:$A$4,Sheet1!$A$6:$A$8), (Sheet1!$B$2:$B$4,Sheet1!$B$6:$B$8),1)