jmac001
asked on
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
Pivot-Test.xlsx
You can filter your data and on chart you will also see filtered data.
ASKER
I tried filter and it was not filtering out the data
Can you upload sample with unfiltered chart? Do you like something like this sample?
Pivot-Test.xlsx
Pivot-Test.xlsx
ASKER
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?
You need additional column with these groups
Pivot-Test.xlsx
Pivot-Test.xlsx
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That makes more sense, thanks for all of your help.