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.


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: copy & paste - word - Office 2000 - XP / SP3 [Solved],Troubleshooter of Error: Crash Report - Shows that Internet Explorer stops working every time it is closed,How to Resolve - Copy from multiple workbooks into multiple worksheets?,Troubleshoot:cross site script error when playing facebook game,Solution to Error: CSI payload file missing,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment