Tag: pivot table
-
Excel Pivot Table Trick: Drawing Charts Using Only Part of the Pivot Table
As I showed in a previous post about dash-boarding with Pivot Table, generating multiple charts with a Pivot Table can be very useful. But the problem is that Excel will automatically take the entire Pivot Table and generate a chart. You cannot even delete any data points from that chart(!), because they are part of…
-
Filter Data Right in your Pivot Table Fields!
One of the ‘hidden treasure’ in Pivot Table a lot of people do not know about is that you can filter data right in your Pivot Table Fields. This is extremely useful if you already know before you do your Pivot Table analysis that you would like to select and use only a subset of…
-
Google Sheets is Catching up with Excel in Charting
Excel is still my number one choice when it comes to graphing and charting, or just first-cut exploring, but I have notice that Google Sheets is also becoming more and more capable in its charting department. Do you know Google Sheets have Pivot Table? Do you know that it has a motion chart that even…