4 Replies Latest reply on Nov 27, 2018 8:23 PM by lei.chen.0

    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?