Solved

PivotCharts & Tables

Posted on 2015-01-28
2
67 Views
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
Example-ofChart-1.PNG
Order-Tracking-012715.xlsx
0
Comment
Question by:Marcia Morris
2 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40574698
Hi,

Include Order date then group by months
and move Dec Up

Regards
Order-Tracking-012715V1.xlsx
0
 

Author Closing Comment

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

Featured Post

Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.

Question has a verified solution.

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

This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

830 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