3 Replies Latest reply on Nov 2, 2018 10:19 AM by Kelly McGrady

    Grouped bar chart with data coming from different Excel sheets

    Minoy Jose

      I have two Excel sheets with data as follows:

       

      Table 1:

      Contract ID
      Date 1

       

      Table 2:

      Contract ID
      Date 2

       

      Date 1 and Date 2 are different data points functionally. Contract ID is the common field between the two tables. How do i create a monthly grouped bar chart which shows number of Contract ID for each month from both tables in different bars?

      Lei Chen Any idea?