J
jimt
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.
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.