Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Create PIVOT table

Posted on 2011-03-08
2
Medium Priority
?
302 Views
Last Modified: 2012-05-11
I am trying to construct a PIVOT table to more or less replicate the lower graph on sheet 'Team Dashboard WIP'. I am hoping the pivot table will be easier to read and report off of. The data comes from 'Data Entry'..but no matter how I layout the PIVOT, it looks nothing like the graph on 'Team Dashboard WIP' (the lower one, NOT the bar graph)...
Thanks!!
dashboard-wipv3a---PIVOT.xlsm
0
Comment
Question by:singleton2787
  • 2
2 Comments
 
LVL 15

Accepted Solution

by:
CSLARSEN earned 2000 total points
ID: 35087613
Hi
Suggestion to pivot chart EE-Pivot-sample-Book1.xlsx
Cheers
cslarsen
0
 
LVL 15

Expert Comment

by:CSLARSEN
ID: 35133098
thx for the grade
cheers
cslarsen
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question