You can setup your PIvotTable/Chart, with account being in the row section,
and then de-select "Sub Total, Grand Total, and Blank"

Other option is when you go to make your normal chart and are selecting the
cells to use, hold down Ctrl to select multiple ranges.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jimt" wrote:

I would like to define a range to create a chart. The data spreadsheet is
divided into several sections of row with financial account groups (similar
to departments). Each of the groups has a total line and a blank separator
line between the groups. Each row has a "type" of account. So the data sheet
look something like:

acct type amount
1 A 5.00
2 A 2.00
3 A 1.00
sub-total 8.00

4 B 1.00
5 B 2.00
sub-total 3.00

Group Tot 11.00

6. C 6.00
7. D 3.00
Group Tot 9.00

Grand total 20.00

Is there a way to define a non-contiguious range name or a pivot table that
excludes the "totals" and blank rows so that the resulting chart displays the
sum field for the different type?

Thanks
Jim T.