Home

Pivot Chart Hiding Data

%3CLINGO-SUB%20id%3D%22lingo-sub-42120%22%20slang%3D%22en-US%22%3EPivot%20Chart%20Hiding%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42120%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20a%20pivot%20table%20and%20I%20have%20all%20of%20the%20data%20that%20I%20need%20there.%20%26nbsp%3BWhen%20I%20use%20the%20pivot%20chart%20it%20pulls%20in%20all%20of%20the%20data%20columns%2C%20which%20I%20only%20want%203%20of%20the%205%20columns%20to%20pull%20into%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-42120%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-370190%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Chart%20Hiding%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-370190%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20change%20the%20fill%20color%20of%20the%20bars%20you%20don't%20want%20to%20see%20to%20no%20fill%20and%20do%20some%20alignment%20work.%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F37897%22%20target%3D%22_blank%22%3E%40Jeffrey%20Sbonik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42279%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Chart%20Hiding%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42279%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jeffrey%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20option%20would%20be%20to%20make%20a%20copy%20of%20the%20Pivot%20table%20and%20remove%20the%202%20unwanted%20columns%20for%20your%20chart%2C%20%26nbsp%3Byou%20could%20then%20use%20Slicers%20to%20control%20both%20Pivot%20Tables%20at%20the%20same%20time%20(assuming%20you%20have%20Excel%202010%20or%20later).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei.e.%20one%20pivot%20table%20contains%20all%20the%20data%20you%20want%20to%20see%20and%20one%20controls%20your%20chart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-42179%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Chart%20Hiding%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-42179%22%20slang%3D%22en-US%22%3E%3CP%3EJeffrey%2C%20for%20my%20knowledge%20you%20can't%20do%20that%20as%20far%20as%20your%20pivot%20chart%20is%20linked%20to%20the%20pivot%20table%2C%20without%20deleting%20fields%20in%20both.%20%26nbsp%3BIMHO%2C%20the%20easiest%20way%20to%20break%20that%20link%20is%20to%20create%20the%20pivot%20chart%20independently%20from%20pivot%20table.%26nbsp%3BMost%20probably%20your%20data%20is%20in%20data%20model%20(default%20option%20when%20you%20create%20pivot%20table)%2C%20if%20so%20insert%20power%20chart%26nbsp%3Bfrom%20Power%20Pivot%20menu%2C%20without%20creating%20another%20pivot%20table.%20If%20you%20don't%20work%20with%26nbsp%3Bdata%20model%20for%20any%20reason%2C%20second%20pivot%20table%20could%20be%20created%20in%20separate%20worksheet%20(which%20you%20may%20hide%20later%20on)%20to%20create%20the%20power%20chart%20on%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jeffrey Sbonik
New Contributor

I am working on a pivot table and I have all of the data that I need there.  When I use the pivot chart it pulls in all of the data columns, which I only want 3 of the 5 columns to pull into chart.

3 Replies

Jeffrey, for my knowledge you can't do that as far as your pivot chart is linked to the pivot table, without deleting fields in both.  IMHO, the easiest way to break that link is to create the pivot chart independently from pivot table. Most probably your data is in data model (default option when you create pivot table), if so insert power chart from Power Pivot menu, without creating another pivot table. If you don't work with data model for any reason, second pivot table could be created in separate worksheet (which you may hide later on) to create the power chart on it.

Hi Jeffrey

 

One option would be to make a copy of the Pivot table and remove the 2 unwanted columns for your chart,  you could then use Slicers to control both Pivot Tables at the same time (assuming you have Excel 2010 or later).

 

i.e. one pivot table contains all the data you want to see and one controls your chart

Just change the fill color of the bars you don't want to see to no fill and do some alignment work. @Jeffrey Sbonik 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies