Excel: How to Exclude Specific Columns From a Pivot Chart
When you create a chart from a Pivot Table, all the columns from the Pivot Table are used in the chart. Even if you highlight specific columns, Excel ignores that and creates the chart by using all the columns. So how do you include only certain columns from the Pivot Table in the chart? There are several simple ways to do this and in this video I show you 3 of them:
Method 1: Create a second Pivot Table containing only the columns needed and base the chart on that Pivot Table
Method 2: Create a chart with all the columns and hide the unwanted columns in the chart
Method 3: Create a "regular chart" rather than a Pivot Chart
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/9itf4lhla65x5ap...
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #pivottable #chart