Pivot chart trouble

bergen

New Member
Joined
Sep 28, 2011
Messages
31
I am stuck!

I am creating a pivot chart based on data that is updated every month.
The simple question that I need answered is how I can group a number of variabes in different groups so that I can just click on a tab on the chart and choose the group I am looking for.
In this case I have a column with a number of countries which I want to group into regions.

Below I have described my specific situation if it helps.

To simplify things imagine I have these 3 variables
1: Names of sales people in whole company
2: Country of sales people
3: Sales numbers per sales person

Now what I am looking for is simple enough I want to create a chart with sales numbers on the y axis and names of sales people on the x axis, and the option of toggling this view to show employees of different regions.

The first step I went through was to put fields into the areas at the bottom of the Field List (I will refer to numbers above):
I put 1 in "axis fields". 2 in "Report Filter". 3 in "Values"

Now I have a chart with every employee from every country and the ability to filter on various countries from the tab at the top of the chart. But if I for example want to chosse Nordic region I need to select both Norway, Denmark, Sweden and Finland. Instead I would like to be able to just select "Nordics" and have employees from all these countries shown.

So how can I do that!!??
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Add a region column to your source data and enter the appropriate region for each row of data.
That will give you another field to filter on in the pivot table/chart.
 
Upvote 0

Forum statistics

Threads
1,211,678
Messages
6,103,236
Members
447,848
Latest member
holale

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top