# total and total by selected quarter pivot table and then chart representation

1. ## total and total by selected quarter pivot table and then chart representation

All,

I don't know if I'm just having a series of brain farts today or what, but unbelievably I'm stumped again. I've tried pivot tables and manipulated them several different ways among several other things and I can't get the desired effect.

Here's my end goal: Have a chart, a stacked column chart (boss' request), that depicts defects by total versus Q3-16 (this time, I'll need to do it for Q4-16 next time). So in the attached example, there would be a total thus far of 12 "to be determined" 7 of which occurred in Q3-16. So ideally it would show a column reaching 12 and 7 of that column being Q3-16.

I've tried several different pivot table combinations to try and make this happen and I can't seem to get it to work.

So I figure either I am missing something simple when setting up the pivot table, or there is something about my Table that isn't allowing me to achieve my desired result. The table can be adjusted or added on to with some exceptions, but I'll take suggestions regardless and deal with them.

I'd want my PivotTable and Chart (pivot or otherwise) on a separate sheet from the two already existing sheets.

Any help or guidance would be greatly appreciated!

2. ## Re: total and total by selected quarter pivot table and then chart representation

Have you tried using Defects (filtered to show only "To Be Determined") and Quarter as the column titles, then Defects (Count of) as the values?

3. ## Re: total and total by selected quarter pivot table and then chart representation

Jete,

That would only help me for that one defect. That chart needs to depict all the defect (or at the very least, the top ten).

4. ## Re: total and total by selected quarter pivot table and then chart representation

Jete,

That would only help me for that one defect. That chart needs to depict all the defects (or at the very least, the top ten).

5. ## Re: total and total by selected quarter pivot table and then chart representation

This article looks as if it may be helpful.

6. ## Re: total and total by selected quarter pivot table and then chart representation

Not quite what I need either, Jete. I found that one yesterday too. Ugh, is it possible that there's no way to what I need to do?

7. ## Re: total and total by selected quarter pivot table and then chart representation

Take a look at the attached file. I made two charts, one from a Pivot Table and the other from a table. The one made from the table is easier to manipulate as you can directly filter the defects that occurred during the 3rd quarter, whereas with the PT chart you have to manually remove those defects that did not occur during the 3rd quarter.
Let me know if you have any questions.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1