Solved

Create PIVOT table

Posted on 2011-03-08
2
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 15

Accepted Solution

by:
CSLARSEN earned 500 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
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 will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

615 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