PivotCharts & Tables

Posted on 2015-01-28
Medium Priority
Last Modified: 2015-01-28
I am trying to compare the data for the months of Dec & Jan using a stacked column chart (looking at how long it takes for order to be inputted and flowed down within inside sales). I am having trouble separating the data so that I can see both months on one chart for the month ie., Dec FP & Jan FP AND Jan RP & Jan RP (example pic of chart I am looking for is attached). What am I not doing correctly? In 'sheet 17' the chart is there but I can't get it to do what I want. I am using the 'order date' as the Dec & Jan date to compare and when I added it to the pivot chart and filtered it I wasn't getting the side by side view of each month (so I took it out). Am I using the incorrect chart?

The formulas in the data tab were created by another person and I was instructed to use the averages in columns I, J, K to put the chart together. When I do the pivotchart and I switch value field setting from count to average, am I averaging the averages??? I feel as if I am but I am not good at pivot tables (sighhhh...how did I get this project?). That's how the person that handed this down to me created the previous charts.

I also couldn't figure out how to add the counts (example DEC CHART) so I manually added the numbers for that example. But I don't want to keep doing it manually if there is a way to do it as I eventually will compare by quarter and/or months for the entire 2015.

Thanks in advance
Question by:Marcia Morris
LVL 54

Accepted Solution

Rgonzo1971 earned 2000 total points
ID: 40574698

Include Order date then group by months
and move Dec Up


Author Closing Comment

by:Marcia Morris
ID: 40575586
Thank you so much Rgonzo1971.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This article will shed light on the latest trends when it comes to your resume building needs. For far too long, the traditional CV format has monopolized the recruitment market.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

627 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