• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

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
0
jmac001
Asked:
jmac001
  • 4
  • 4
1 Solution
 
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
 
als315Commented:
Can you upload sample with unfiltered chart? Do you like something like this sample?
Pivot-Test.xlsx
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
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
 
als315Commented:
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
 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now