Pivot Charts and Grouping

This is probably easy but not able to figure it out.  I need to create a pie chart that show all projects that are overbudget by Reason.  I have the variance in the data and need to only show when the it is over 5%. Can some one help, the sample file is attached.
Pivot-Test.xlsx
jmac001Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
als315Connect With a Mentor Commented:
You should at first add column to sheet1 with formula:
=IF(J2<0.05,"<5%",">=5%")
then select this new column and add pivot chart. Add it to axis fields(Categories) and to value (as count of), change chart type to pie:
pivot chart
0
 
als315Commented:
You can filter your data and on chart you will also see filtered data.
0
 
jmac001Author Commented:
I tried filter and it was not filtering out the data
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
als315Commented:
Can you upload sample with unfiltered chart? Do you like something like this sample?
Pivot-Test.xlsx
0
 
jmac001Author Commented:
One more question is there a way to group the variance % 0-4.99% and 5%+ so that I can show that number of projects?
0
 
als315Commented:
You need additional column with these groups
Pivot-Test.xlsx
0
 
jmac001Author Commented:
That is actually what Im looking for but having a little problem with recreating.  
These are the stops I have tried and keep getting an error:  Using 2010:

Insert Pivot, Pivot Table Tools, Options,  Fields.Items.Sets, Calculated Field, Name = Group, what do I place in formula and do I need to do anything with the actual table of data?
0
 
jmac001Author Commented:
That makes more sense, thanks for all of your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.