+ Reply to Thread
Results 1 to 2 of 2

Plotting Charts Of Orders Per Day

  1. #1
    Registered User
    Join Date
    07-29-2016
    Location
    Amsterdam
    MS-Off Ver
    12
    Posts
    1

    Plotting Charts Of Orders Per Day

    I'm a real Excel noob, so please excuse my ignorance, but I could use a little bit of help with plotting graphs.

    So basically I have an excel sheet provided by my fulfilment centre which shows (among other things )the order name and the order date. For simplicity sake lets say the sheet looks like this:


    Order Date
    SKU1 21-7
    SKU1 21-7
    SKU2 21-7
    SKU1 22-7
    SKU2 22-7
    SKU2 22-7

    Does anyone now a good way to plot a graph with the amount of orders per day for each SKU and possibly a method to show the average amount of orders per SKU per day over a certain time period?

    Thanks in advance - would really, really help me out!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,603

    Re: Plotting Charts Of Orders Per Day

    Are those proper dates (with the year hidden by formatting), or text values that just look like dd-m ?

    First of all, you should derive a table to put the data in the format that you want to show on the graph. You should list the individual order names (SKUs) across the top of the table, and the dates down the left side of the table, and then you could use a COUNTIFS formula to count how many of each order name occur on the different dates. From that you can plot a graph showing the orders per day on the Y axis and the dates on the X axis, where the SKUs are different series (i.e. different lines on the graph, usually in a different colour).

    You can use an AVERAGEIFS formula to derive the average over a specific period (eg. monthly) in a separate table.

    If you feel you need some extra help to show you how to do these things, then it would be a good idea if you attached a sample Excel workbook. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with plotting charts
    By geraldccole in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2016, 05:05 AM
  2. Help with plotting multiple charts
    By max12 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2014, 12:31 PM
  3. Replies: 0
    Last Post: 06-28-2011, 05:04 AM
  4. Plotting Reliability Charts
    By futamura in forum Excel General
    Replies: 10
    Last Post: 05-20-2011, 02:09 PM
  5. Plotting bar & line charts
    By xya in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-16-2009, 09:14 PM
  6. How do I keep zero values from plotting in charts?
    By BrianBrand in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-11-2006, 05:10 PM
  7. [SOLVED] Plotting charts
    By Atogeniqua in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2005, 07:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1