3 Replies Latest reply on Oct 16, 2013 11:50 AM by Johnny Carter

    multiple date based variables on one axis

    Johnny Carter

      I have in a database a list of projects and they have a completion date and a start date and I'm wanting to get them on a line chart broken down by month where I can see how many were started within each month and how many were complted within each month. I started by doing a calculation for count([completion date]) and count([start date]) This works fine as long as I keep them on seperate charts, but I really want this on one chart with one axis. I can't post my workbook, so I've recreated the same thing in the superstore sales workbook using order and ship date. You can see when they are on their own seperate sheets the graphs look different, but when put on one sheet it no longer works correctly. I think what I need is a generic date axis instead of using one of my variables as the date axis.