I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (details of each listing). I have the data filtered, grouped, and summarized. The summary, for example, gives me 11 total items for January. All I want to be able to do is use that count (11) in a Dashboard chart where I will track each summary total by month. However, when I try to chart the data, it wants to chart all of the details and I cannot get it to just give me the count. I could go write formulas to pull all of this data into another sheet but 4 sheets x 12 months is 48 formulas that I would rather not write as this seems something so simple that a report should be able to do and not require me to restate the data elsewhere. What am I doing wrong?