• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Grouping date & time in chart

C

Centralpark

New Member
Hi, I have two sets of data. Column A is "department" and column B is "Order time" (which is in date+time format). I am trying to show this in a graph but want to club(or count) time" together and show it as a total sum without manipulating the data.

DepartmentOrder Time
ULTRASOUND05/01/14 12:57:
ULTRASOUND05/01/14 18:36:
ULTRASOUND05/01/14 20:43:
ULTRASOUND05/01/14 23:02:
ULTRASOUND
05/02/14 00:32:

On X-axis, I want to show "order time" but just show "5/01/14" and on Y-axis, the series should go upto "4". For 5/2, the graph will just show 1 and so on and on.

Is there any automated way to show this when I do this in a graph or do I have to count them before plotting the graph?
 
You will need to do something. You could create a PivotChart, and it can do the calculations for you, which if your data is going to fluctuate, would be my first recommendation. You could use the Group ability on the Dates to group by Days, and then that should produce what you desire. Note that your Data field would be a Count of Dates. Without in-cell formulas or a PivotTable, XL has no way of knowing that you want to group the data the way you desire.
 
I tried the pivot chart but it was still showing dates with times in the X-Axis, with 4 different graphs rather than 1. I couldn't find a way to count all the 4 into 1 graph. Am I missing anything?
 
You must log in or register to reply here.
Back
Top