Graph of events in time

  • Thread starter Thread starter jeichner
  • Start date Start date
J

jeichner

I would like to create a graph using an Excel spread sheet. The Excel spread
sheet shows when orders are made for work. I want to look at which day of
month or week of the month most orders are made. I want to see a graphical
representative of when orders are coming in.
 
Basicly this should be quite easy to do.. but as always it depends on the way
your information is stored in the spreadsheet. Are it dates, are day and
month seperated? Is a week number allready declared? etc. etc. And how are
they placed within your worksheet?
 
Assuming you have a list of dates when orders were placed. Put a label in
the cell above the list, then select the list, and go to Data menu > Pivot
Table and Pivot Chart Reports. Make a pivot table using this data, place it
on the same worksheet (I find this easier). Now you have a blank pivot
table. Drag the date field to the Rows area, then to the Data area (yes, use
it twice). This gives you a list of dates and a count of orders for each
date. You can now group the date field in the rows area in various ways. I
discuss grouping by dates here:
http://peltiertech.com/WordPress/grouping-by-date-in-a-pivot-table/

- Jon
 
Back
Top