Sound Card Driver Updating: Tech Support: Create a pivot chart with rankings

Friday, September 23, 2016

Tech Support: Create a pivot chart with rankings

Create a pivot chart with rankings

We are conducting a training needs analysis of a group of our staff (will be 3-400 in total) and have collated this data on an Excel 2010 spreadsheet. We want to make a pivot chart of this data.
Column headings are the questions (eg can you fill in forms on the internet?; Have you used xxx before, etc.) - 12 questions in all
In rows we have business unit, first name, last name and what they ranked each question (from 1 - 4). A key on the side shows what each ranking means, 1 = "No", 2 = not sure, 3 = Yes but need some help, 4 = Yes very confident.

We want to be able to create a pivot chart that shows a summary of number of rankings for each question, that we can drill down and see results for each business unit.
I am rusty with pivot charts, but is this possible?
Many thanks in anticipation.
Michelle

Anwsers to the Problem Create a pivot chart with rankings

Download SmartPCFixer for Free Now

You may make a summary report like this screen shot, where I have used following formula at R4 and dragged it right/down.
=SUMPRODUCT(($D$1:$O$1=$Q4)*($D$2:$O$21=R$1)*($A$2:$A$21=$Q$1))
At Q1 I have given a Data Validation List for BU's so now once you select a BU from the drop down, accordingly the summary report will update and with that chart will be updated.
All is dynamic.
Like this you may create multiple reports as per your need and create different charts/layouts.
Hope it helps.
For better visibility of chart, you should copy it on a blank sheet.

Make Sure that your Computer Meets the System Requirements

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you update where necessary before continuing:

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

If your computer meets the minimum requirements above, then continue on…

Recommended Method to Repair the Problem: Create a pivot chart with rankings:

How to Fix Create a pivot chart with rankings with SmartPCFixer?

1. Download Error Fixer. Install it on your system.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.