5 Replies Latest reply on Apr 16, 2013 11:00 AM by Allan Walker

    How do I show data that has two date fields on one date axis in a graph?

    peter.greenway

      How do I compare data that has two date fields on one date axis in a graph. For example as bid date and orders accepted date. In excel I create a new date field to allow me to do this and then reference the as bid and orders accepted amounts to it.

      The date are held as two date fields - as bid date and orders accepted date

      DatesMar-12Apr-12May-12Jun-12
      Orders Accepted $M$0.004 M$0.632 M$0.169 M$0.418 M
      Opportunities bid $M$6.142 M$1.048 M$0.802 M$1.562 M